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)?
- 16 Answers
- 21605 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
What is difference between delete & truncate commands?
Differentiate between ms sql server reporting services vs crystal reports?
What is difference between view and materialized view?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
How can sql server instances be hidden? : sql server security
How can i Relate Tables in SSIS
What area unit the various kinds of info compression introduced in sql server 2008?
Do you know what is lock escalation?
What is attribute? : sql server analysis services, ssas
What is the difference between index seek vs. Index scan?
Can binary strings be converted into numeric or float data types?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
what is the difference between openrowset and openquery?
What is a functions and types in sql server?
What is ddl and dml commands?
