How to get Random row picking from table where no int column

Home >> Dababase Interview Questions >> Sql Server 2000 Query

Posted on June 8th , 2009 by Admin

	SELECT TOP 10 * FROM tblname WHERE condition ORDER BY NEWID()