Get First N Records
Posted on 2000-04-13
This isn't really strictly a VB question, but I'll try it anyway.
ENVIRONMENT: VB6 SP-3, ADO 2.1, Oracle 8i.
I need an Oracle-friendly SQL statement that can return the first n records from a given table, using a sort criteria specified by me--or using no sort criteria at all, and relying on the native row ordering.
Selecting the entire rowset, then using GetRows() or something like that isn't really useful. I could have gajillions of records in this table, and I just need the first 28--and exactly 28.
Is there any way to do this? Closest thing I know of is "SELECT TOP N PERCENT", but that's a Jet-thing only, besides not fitting the bill anyway.
Seems like I would have heard of something by now if there were a way to do this. I think it's a no-go.
Thanks in advance for any helpful help.