select and random number

[bisanthe]

hi, (newbie)
hi i have generated a random number
lower = 1
upper = select count(*) from table where criteria
random = Round(((@Upper - @Lower -1) * Rand() + @Lower), 0)

let say random = 8
and upper = 18.
how can i get 8. result in
select * from table where criteria --statement.

 

[bisanthe]

i found a solution i hope this help other guys
(mssql)
select top 1 * from table where criteria order by newid()
i am not sure but mysql is using limit instead of top.