How to display random records in SQL Server Select Query

nedash

I have House_info table in database

and in House.aspx page I have datalist that bind it from database

before I wrote in SP

order by [Maxdate] desc

and in datalist it show data according Maxdate desc

Now I want it show data in datalist in Random...

How I can do it?

Best Regards

Neda

Mudassar

0 1

If you want to show data randomly then use

order by NewId()

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html