How to (or Can I) select a random value from the Postgresql database excluding some particular records?

Question

Is it possible to randomly select a record from the database excluding some records with particular status?

For eg,

For example, I have a table for storing employee details.

id    employeename employeestatus
 1    ab           1
 2    cd           1
 3    ef           2
 4    gh           1
 5    ij           1

What I want from the query is to fetch a single random record whose status is not 2. Is it possible to do so? The database I'm using is PostgreSQL 8.4.15.

score 2 · Accepted Answer · edited Dec 21 '12 at 10:44

2

TRY This

SELECT * 
FROM   employee 
WHERE  employeestatus != 2 
ORDER BY RANDOM()
LIMIT 1

edited Dec 21 '12 at 10:44

Leigh

28,765
10
55
103

answered Dec 21 '12 at 07:00

Reshil

471
3
9

score 1 · Answer 2 · edited May 23 '17 at 11:48

1

Try this other question on the same topic

Best way to select random rows PostgreSQL

It's tricker than you think (to do efficiently)

edited May 23 '17 at 11:48

Community

1
1

answered Dec 21 '12 at 09:27

Richard Huxton

21,516
3
39
51

How to (or Can I) select a random value from the Postgresql database excluding some particular records?

2 Answers2