I want to select X number of records out of Y number of records.
How do i do that ?
i.e. suppose I have 100 records(Y)
I want to select 50 records(X) out of these 100 records
How do I do that ? And if I want to select 50% (or 20%), how do I do that ?
Is it different in DAO/ADO ?
select X...? I have no clue