SQL Select Command

OBJECTIVE

In this chapter you will learn:

Select command
Syntax of select command
Example of select command

 

About select command

Select command is the one of most usable command of SQL Server which is used to retrieve data from database table. It is also known as Select statement and used with other retrieve commands to retrieve some specific data.

Syntax of select command

1. Select * from table_name
2. select column_name from table_name
3. select column_name1, column_name2 from table_name
4. select * from table_name where condition

Example of select command

 

image of select command

 

SUMMARY

In this chapter you have learned about select command of Sql Server. You will learn about distinct command in next chapter.


Leave a Reply

Your email address will not be published. Required fields are marked *