Posted on: 9/12/2013 4:59:35 AM | Views : 675

Hi Friends,
I have tabel with more than 2 lakhs. If I use the following query then it shows approx 1 Lakh.
select * from MyTable where deleted=0 order by entryDate
The Query result is approx 1 Lakhs.
Can I Use Multiple Queries to get the result of the above query result into 4 parts.
if I use  select top 25000 * from MyTable where deleted=0 order by entryDate  then it will show 25000 records.
How can I split the rest of the records with 25000 records ?
Please help

...

Go to the complete details ...