samedi 6 juin 2015

How to Sql random between two rows

I want to 5 random rows in the last 10 records

select top(5) * from My_TBL order by /*DESC*/ NEWID()




Aucun commentaire:

Enregistrer un commentaire