|
In the previous section, we saw how LIMIT can be used to retrieve a subset of records in MySQL. In Microsoft SQL Server, this is accomplished using the TOP keyword.
The syntax for TOP is as follows:
SELECT TOP [TOP argument] "column_name"
FROM "table_name"
where [TOP argument] can be one of two possible types:
1. [N]: The first N records are returned.
2. [N'] PERCENT: The number of records corresponding to N'% of all qualifying records are returned.
For example, we may wish to show the two highest sales amounts in Table Store_Information ,
Table Store_Information
| store_name |
Sales |
Date |
| Los Angeles |
$1500 |
Jan-05-1999 |
| San Diego |
$250 |
Jan-07-1999 |
| San Francisco |
$300 |
Jan-08-1999 |
| Boston |
$700 |
Jan-08-1999 |
we key in,
SELECT TOP 2 store_name, Sales, Date
FROM Store_Information
ORDER BY Sales DESC;
Result:
| store_name |
Sales |
Date |
| Los Angeles |
$1500 |
Jan-05-1999 |
| Boston |
$700 |
Jan-08-1999 |
Alternatively, if we want to show the top 25% of sales amounts from Table Store_Information, we key in,
SELECT TOP 25 PERCENT store_name, Sales, Date
FROM Store_Information
ORDER BY Sales DESC;
Result:
| store_name |
Sales |
Date |
| Los Angeles |
$1500 |
Jan-05-1999 |
SQL Subquery >>
Link to this page: If you find this page useful, we encourage you to link to this page. Simply copy and paste the code below to your website, blog, or profile.
Copyright 1999-2009 1keydata.com. All Rights Reserved. Privacy Policy
|