how to limit my record results

[ryan]

i'm using sql 2000 and i want to select a row out of a table but the number of rows i want to return is only 1. using the LIMIT command doesn't work. is it me or sql 2000?

 

[ryan]

i found the answer ... just type this:

select whatever TOP 1 from ......

this will return only 1 record

 

[foxdev]

And if you want a specific "top" record, remember to use the ORDER BY clause.

Robert Bradley

http://www.foxdev.com/

 

[TomSark]

You can use TOP, or if you want your queries to be compatible with SQL Server 6.x as well as Sybase you can also use:

SET ROWCOUNT 1 -- return one row

SELECT *
FROM mytable

SET ROWCOUNT 0 -- turn it off

Thanks,

Tom

 

[foxdev]

Tom, I assume (but not sure) that the ORDER BY still affects which row is ultimately returned, yes?

Robert Bradley

http://www.foxdev.com/

 

[TomSark]

As we say in Texas, "Yup" LOL

Tom

 

[foxdev]

That's "yep"...didn they learn you that in schoo ?

Remember, in case you use both techniques: the SET ROWCOUNT statement will override the SELECT statement's TOP clause if the SET ROWCOUNT is smaller.

Robert Bradley

http://www.foxdev.com/

 

[TomSark]

"Yep" is for city slickers. True country folk use "yup". ;-)

Tom