SQL–Basic Select

 

SQL –> Structured Query Language.

In this tutorial series, we’ll restrict ourselves to more examples which makes the concepts self explanatory.

Select * from TABLE_NAME;

select * from Person;

Explanation: Selects all the column from a table, like person table in the above example.

Select Id, FirstName, LastName from Person

Explanation: This query selects the Id, FirstName and LastName columns from Person Table.

Note: Always specify columns instead of using wildcards as far as possible to improve performance.

Technorati Tags: SQL,Basic,Select,Query,Language,tutorial,series,examples,concepts,self,TABLE_NAME,Person,Explanation,Selects,column,example,FirstName,LastName,size,Consolas,Courier,Monospace,margin,width,columns,Table,Note,performance,csharpcode

Windows Live Tags: SQL,Basic,Select,Query,Language,tutorial,series,examples,concepts,self,TABLE_NAME,Person,Explanation,Selects,column,example,FirstName,LastName,size,Consolas,Courier,Monospace,margin,width,columns,Table,Note,performance,csharpcode


WordPress Tags: SQL,Basic,Select,Query,Language,tutorial,series,examples,concepts,self,TABLE_NAME,Person,Explanation,Selects,column,example,FirstName,LastName,size,Consolas,Courier,Monospace,margin,width,columns,Table,Note,performance,csharpcode


Blogger Labels: SQL,Basic,Select,Query,Language,tutorial,series,examples,concepts,self,TABLE_NAME,Person,Explanation,Selects,column,example,FirstName,LastName,size,Consolas,Courier,Monospace,margin,width,columns,Table,Note,performance,csharpcode