Thanks.I just wanted to make sure that its selected randomly.
Is there some method by which we can limit the number of records retrived from a select statemnt to a fixed number and if we try to execute the same select again then the remaining number of records are retrieved?
eg:- I have got a...
Dieter,
By using 'sample' in select statement,can we always get the next set of records?
eg:- I have got 10 records in the table 'customer'
select * from customer sample 5;
When I executed this statement twice,I found that it doesnt give the next 5 records.There were some common...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.