SqlServer series notes-simple query
Simple query select
Simple data retrieval: SELECT * FROM T_Employee
Retrieve only the required columns: SELECT FName,FAge FROM T_Employee
Aliases for column: SELECT FNumber AS number, FName AS name, FAge AS Age111 FROM T_Employee
Use where to retrieve eligible data: SELECT FName FROM T_Employee WHERE FSalary
