SQL Server Simple Query

Simple Query Select

Simple data retrieval: SELECT * from T_employee

Retrieve only required columns: SELECT fname,fage from T_employee

Column aliases: SELECT fnumber as number, FName as name, Fage as Age111 from T_employee

Use where to retrieve qualifying data: SELECT FName from T_employee WHERE fsalary<5000.

Use like fuzzy query SELECT FName from T_employee WHERE FName like ' sheet%

Select can also retrieve data that is not associated with any table: select 1+1;select newid (); select getdate ();

SQL Server Simple Query