Anyone Expert in SQL Queries?

itHighway · May 23rd, 2005, 10:50 PM

Hi,

My Question is related to SQL Query. Let me explain it using an example.

Suppose an access table having records 001,002,003,004,005

Now what I want to do is using Select Query sort the records in such a way that it first display 004 and then the remaining records
So the list will display something like this

004
001
002
004
005

I can only use ONE sql query to sort and display the records in above mentioned format

Thank you,
Zeeshan Ahmed

Imar · May 24th, 2005, 01:08 AM

If you're looking for Sql experts, I think you better ask your question in the Sql forum, and not in the Html forum, don' you think?

Over here, there are just Html experts..... ;)

Imar

grstad · June 3rd, 2005, 09:52 AM

Select count(*) from "your tab-name" where "fiel-name" <> "004"

...and later on in the script when you want to write the list to the screen, start with 004 (if this is current every time) and then you "response.write" the querry!

grstad · June 3rd, 2005, 09:57 AM

ok, I did misunderstand you just a bit! #-) You need to control the cursor to stop by the last record -1! Hmmmm...