Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by saamy

  1. saamy

    Limiting records

    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...
  2. saamy

    Limiting records

    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...

Part and Inventory Search

Back
Top