SQL Select Command

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

select * from humanresources.employee
image of select command
SUMMARY

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

 

Share your thought