limited select

Hello, I'm kinda new with sql so i think my question might be rather simple: I want to select 50000 records from a table which contains 100000 records that all match the <where> condition. How do i tell sql to stop as soon as it has found those 50000 records ? Thanks in advance ! Regards/ ruud Sent via Deja.com http://www.deja.com/ Before you buy.

r.bertrand@libertel.nl writes: > Hello, > > I'm kinda new with sql so i think my question might be rather simple: > > I want to select 50000 records from a table which contains 100000 > records that all match the <where> condition. How do i tell sql to stop as > soon as it has found those 50000 records ? You could either read the documentation and actually _learn_ something, or you could just do: SELECT FIRST 50000 FROM ....... Thomas