SQL help needed

[JADE]

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.

[rmiao]

On which rdbms?

[JADE]

Forgive me but I'm not familiar with rdbms. :-(

[skhanal]

You can, you need to learn SQL language. All database systems understand ANSI SQL syntax.

[JADE]

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?

[rmiao]

Which database do you use? Each vendor has their own functions and so to extend ansi sql.

[JADE]

I use DB2 UDB for iSeries Query Manager in AS400

[rmiao]

You may check db2/400 sql manual.