Supoose we want to show 5 Random News on main page of the website.
SELECT TOP 5 NewsID,Description,DatePosted FROM tblNews ORDER By NEWID()
OUTPUT: 5 News will be fetched from table at Random. each times 5 different news will be picked from the table.
Thanks & Regards
Lakhan Pal Garg