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
SUMMARY
In this chapter, you have learned about the select command of SQL Server. You will learn about distinct command in next chapter.