Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

how to get first 5 records from a dataset having 100 records

3 Posts 3 Posters 0 Views 1 Watching

R Offline
R Offline
romanchita

wrote on last edited by

#1

I hav 100 records in a dataset.how can i fetch the first 5 records from the dataset
M E 2 Replies Last reply

0
R romanchita

I hav 100 records in a dataset.how can i fetch the first 5 records from the dataset
M Offline
M Offline
Matglas

wrote on last edited by

#2

I know that when you have a sql statement MySql support Limit 5. Then you get 5 records. But i dont know if all the database applications support it. Hope it helps.
1 Reply Last reply

0
R romanchita

I hav 100 records in a dataset.how can i fetch the first 5 records from the dataset
E Offline
E Offline
ednrgc

wrote on last edited by

#3

select top 5 fieldname1, ....
1 Reply Last reply

0

Log in to reply