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.