mysql - Retrieve a single distinct value each time the query is ran -

mysql - Retrieve a single distinct value each time the query is ran -

i have column total of resort id's 44 rows, using next query

query-> select distinct resort id schema.table name condition='value' , row number= 1

the above query returns 1 value say='15'

when run multiple returning same value ='15'!!!

i require different value each time query ran

could 1 please help me out.

thanks,

you random resort id using this

select top 1 resortid tablename -- <condition> order newid() asc

mysql sql-server