Any SQL gurus here?

I have a small problema and I hope someone can help me out a little bit!

I nead to have a query limited to the first 1000 results. If the maximum is hit, a message will appear below the count stating: ‘* The maximum output was reached.

Does this do "SELECT TOP 1000"?

Thanks for your help!

 

The easiest way of doing it would be to limit it to 1001 records, only show the first 1000 and have an if statement on if the record count is 1001 then display your message.

 

Thanks for your help

 

No problem, I personally am not any form of SQL guru but "how can i do this" type questions are normally logic questions as much as programming/ syntax etc

 

select * from table limit 1,1000;

try that

 

Thanks everybody

 

SELECT your_fields FROM table WHERE your_conditions ORDER BY your_order LIMIT 0,999

That's the first 1000.

 

For MySQL it is

For MS SQL then the original poster was correct with the TOP 1000 statement