Query to find records
-
hi all i need some help in this query i.e i want to retrieve 5 to 10 records from a table.i don't have identity column in my table for this how can write a query??? can u plz help me.. Thank you
siri
-
hi all i need some help in this query i.e i want to retrieve 5 to 10 records from a table.i don't have identity column in my table for this how can write a query??? can u plz help me.. Thank you
siri
hi Please Explain in Detail , or Show us what did you do before you decided to post. We can Help you if you explain in Detail Thanks
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za
-
hi Please Explain in Detail , or Show us what did you do before you decided to post. We can Help you if you explain in Detail Thanks
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za
hi Currenctly iam displaying top 5 records(latest entered) from a table. now i want to display next five records. this is what i want to do thank you.
siri
-
hi Currenctly iam displaying top 5 records(latest entered) from a table. now i want to display next five records. this is what i want to do thank you.
siri
What you are Requesting is SQl Paging, try this
select top 10 * employees from employees where NOT employee_id IN (select top 10 employee_id from employee)And look at this http://www.petefreitag.com/item/59.cfm[^] or http://www.sqlteam.com/article/whats-after-top[^] And as you can see the above Example and links, requires you to have a Primary key for your table Thanks Hope it helpsVuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za