...

View Full Version : ASP- SQL Server..Query help....



phantom007
01-31-2007, 06:19 AM
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 -


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

degsy
01-31-2007, 11:46 AM
You have only specified one ORDER BY field. AFAIK after ordering by that field the rest of the order will be random.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum