Printable View
Can someone tell me if there is an operation/command that will allow me to pull a sample from a group of data? For example, I might say, if user id is populated >= 3000 return a sample of 50. Or if population is <= 500 return a sample of 5.
Is this something SQL is capable of?
Would really appreciate any help I can get.
On which rdbms?
Forgive me but I'm not familiar with rdbms. :-(
You can, you need to learn SQL language. All database systems understand ANSI SQL syntax.
I have query results but need to know how to make the query return only a sample from the total population. The samples need to be random. Can someone just point me in the right direction? Which SQL operation/command do I need to research to accomplish the above task?
Which database do you use? Each vendor has their own functions and so to extend ansi sql.
I use DB2 UDB for iSeries Query Manager in AS400
You may check db2/400 sql manual.