Hi! I used this method random by newid().
DECLARE @fruitetable AS TABLE(Id INT,Name VARCHAR(50))
INSERT INTO @fruitetable VALUES(1,'Apple')
INSERT INTO @fruitetable VALUES(2,'Melon')
INSERT INTO @fruitetable VALUES(3,'Chary')
INSERT INTO @fruitetable VALUES(4,'Grapes')
INSERT INTO @fruitetable VALUES(5,'Apple')
SELECT Top 3 * FROM @fruitetable order by newid()
Can I use other method random without using newid(). Who is you can help me with example?