•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP section within the Web Development category of DaniWeb, a massive community of 423,464 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,836 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP advertiser: Lunarpages ASP Web Hosting
Views: 1662 | Replies: 1
 |
•
•
Join Date: Dec 2004
Location: India
Posts: 234
Reputation: 
Rep Power: 4
Solved Threads: 0
Posting Whiz in Training
ASP- SQL Server..Query help.... Hello,
I am using ASP and MS SQL Sever 2000 as backend database..
I am writing a SQL query which will pick up top 5 recipes details who have scored the highest marks from the following table
tblrecipes -
The following points to be noted:
- The table has 500 records.
- 50 of them have achieved the highest marks ie 100 marks each
- My following query is picking up top 5 records who have scored 100 marks
and getting this output:
http://img2.freeimagehosting.net/uploads/3d14a5272a.jpg
Now my question is:
On what basis its showing up this sequence of listing? I mean why the ID 89 is on the top and 136 at the bottom? Why the ID is not the other way round?
Like the following?
ID
__
178
136
89
286
340
Can someone explain please?
Thanx
I am using ASP and MS SQL Sever 2000 as backend database..
I am writing a SQL query which will pick up top 5 recipes details who have scored the highest marks from the following table
tblrecipes -
ID | recipe_name | Total
The following points to be noted:
- The table has 500 records.
- 50 of them have achieved the highest marks ie 100 marks each
- My following query is picking up top 5 records who have scored 100 marks
SELECT TOP 5 ID, total, recipe_name FROM tblrecipes ORDER BY total DESC
and getting this output:
http://img2.freeimagehosting.net/uploads/3d14a5272a.jpg
Now my question is:
On what basis its showing up this sequence of listing? I mean why the ID 89 is on the top and 136 at the bottom? Why the ID is not the other way round?
Like the following?
ID
__
178
136
89
286
340
Can someone explain please?
Thanx
•
•
Join Date: Sep 2004
Location: Plymouth, UK
Posts: 79
Reputation:
Rep Power: 5
Solved Threads: 1
Junior Poster in Training
Try
The thing is that you haven't manetioned to sort the ID colums as well. So IDs appear in the order of last modified data/time.
SELECT TOP 5 ID, total, recipe_name FROM tblrecipes ORDER BY total DESC, ID DESC
The thing is that you haven't manetioned to sort the ID colums as well. So IDs appear in the order of last modified data/time.
|
•
•
•
•
•
•
•
•
DaniWeb ASP Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
.net ad advertising ajax architecture asp backup beta business centro custom daniweb database dell developer development dom doubleclick enterprise feed google hacker internet linux longhorn mail microsoft mmorpg msdn news novell office qmail reader security server skin smtp software source sql survey suse theme vista weather windows windows server xml xoap
- Freelance Web designer PHP, MySQL, ASP, SQL Server 2000 (Post your Resume)
- ASP/SQL - Problem (ASP)
- Freelance Web designer PHP, MySQL, ASP, SQL Server 2000 (Web Development Job Offers)
- Professional Freelance Web designer India PHP MySQL ASP SQL Server (Community Introductions)
- How i Can connect Sql Server with ASP (ASP)
- How to connect ASP with sql server ? (Community Introductions)
Other Threads in the ASP Forum
- Previous Thread: Where can I get a Library of std ASP functions
- Next Thread: error '80020009' Exception occurred.
