As I have discussed in my first SQL article that the database scenario is AdventureWorks, on which we will work on. The AdventureWorks database is stored on the LocalDb (Currently used) database server. The problem we are sorting out is, the details of the sales persons are stored in the SalesPerson table. The management wants to view the details of the top three sales persons who have earned a bonus between $4,000 and $6,000.
To retrieve the specified records, programmer need to create a query first and then execute the query to generate the report. To display the top three sales person records from the SalesPerson table, programmer need to use the TOP keyword. In addition, to specify the range of bonus earned, you need to use the BETWEEN range operator.
To create the query by using the SQL Server Management Studio, just follow simple steps written below:
FROM [AdventureWorks2012].[Sales].[SalesPerson]
Where Bonus BETWEEN 4000 AND 6000
To retrieve the specified records, programmer need to create a query first and then execute the query to generate the report. To display the top three sales person records from the SalesPerson table, programmer need to use the TOP keyword. In addition, to specify the range of bonus earned, you need to use the BETWEEN range operator.
To create the query by using the SQL Server Management Studio, just follow simple steps written below:
- Select Start>Programs>SQL Server Management Studio to display the Microsoft SQL Server Management Studio Window. Connect to Server dialog box is displayed by-default, if not you can simple open it from File>Connect Object Explorer.
- Select the server name from the Server name drop-down list.
Note: Name of the server is computer specific. In this example, the name of the server is (LocalDb)\v11.0. You can use the default server as the database server. - Fill the details as given in the image and click on Connect button. It will connect to the server and management studio will be displayed as shown in the image.
- Expand the Databases node and it will show all the databases on this server. Now right click on AdventureWorks2012 database and select New Query.
- Name of the Query Editor window is specific to machine.
- Type the following query in the Query Editor window:
FROM [AdventureWorks2012].[Sales].[SalesPerson]
Where Bonus BETWEEN 4000 AND 6000
- Click on Execute (in SQL editor toolbar) or press F5 and check the result as shown in the following image:
Tidak ada komentar:
Posting Komentar