i have a query which will result 10 or 20 or any number number of rows. Below is the query.
select bookname from bookstore where recommend='true' and Year(pubdate)='2013'
This query can give me any number of rows.
But i have to show just 4 rows from the result. I can select top 4 but i would like select randomly so that every time same book name is not shown through out the year for the users when they visit.
Please help me how to get random rows from the result.