Select

Select Statement:

Syntax: SELECT “column_name1”, “column_name2”,………… “column_nameZ” FROM “table_name”

Example: SELECT name, age FROM employee

The Above example assumes employee table to be present in default schema which is dbo. We can use Fully qualified name as shown below instead

SELECT name, age FROM TestDB.Test.employee

In the above statement the ‘Test’ is the Schema name in which employee table exist.