SELECT TOP 5 column FROM table ORDER BY NEWID()

how to find the particular row in table?(means suppose one
table contain 10 rows , in these 10 rows how to find the
particular row(example in 10 rows i want 5 row how)?

Question Posted / ritu saini

16 Answers
25820 Views
Accenture, IBM, Marlabs, I also Faced
E-Mail Answers

Answer Posted / ritu saini

SELECT TOP 5 column FROM table
ORDER BY NEWID()

Is This Answer Correct ?

14 Yes

25 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What do you mean by the term 'normalization'?

1214

What are statistics?

1005

How global temporary tables are represented and its scope?

977

How to provide default values to stored procedure parameters?

1068

explain extended properties

994

What is database isolation in sql server? : sql server database administration

1114

what are the types of indexes? : Sql server database administration

1126

What is difference between clustered index and non clustered index?

1079

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1069

What are locks in sql?

986

What is difference in performance between insert top (n) into table and using top with insert?

1052

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1080

Can binary strings be used in arithmetical operations?

939

What is the difference between cartesian product and cross join?

867

What do I need to start working with sql studio? : sql server management studio

1122