SQL PHP HTML ASP JavaScript articles and free scripts to download

TOP in SELECT MSSQL query

We can collect some records from a large number or records of a MSSQL table by using TOP clause in our query. We have to specify the field where we want to apply the TOP command and number of records we want to retrieve.

We will apply TOP command to our student table. (You can download the data and structure of the table at our SQL SELECT section.) . Using this command we can collect first n records ( say 5 here ) from the table. Here is the query.

rs1.open " select TOP 5 class, name,sex,mark from student " , conn

Note that the above query is to be applied to the script we have written in our SQL select section. You have to replace the above query line in appropriate place. ( we are not repeating the same script again here ) .

The command TOP only searches for 5 records and it does not go in any order. Let us try to collect to 10 students based on the mark they have secured. Here we will use another sql command ORDER BY ( Read more on ORDER BY command in our SQL section ) . Here is the command.

rs1.open " select TOP 5 class, name,sex,mark from student ORDER BY mark " , conn

The above query will return 5 lowest mark records. By default the order by clause return in ascending order so to change that we have to add DESC to the query to get top 5 rank holders in student table.

rs1.open " select TOP 5 class, name,sex,mark from student ORDER BY mark DESC " , conn

You can read more on order by command in our sql section.

Be the first to post comment on this article :


Google+

Post Comment This is for short comments only. Use the forum for more discussions.
Name
Email( not to be displayed)Privacy Policy
1+2=This is to prevent automatic submission by spammers. Please enter the result of the sum as asked



Join Our Email List
Email:  
For Email Newsletters you can trust
HTML . MySQL. PHP. JavaScript. ASP. Photoshop. Articles. FORUM Contact us

©2000-2014 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer