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
- 21522 Views
- Accenture, IBM, Marlabs, I also Faced
- E-Mail Answers
Answer Posted / anup kumar pandey
There are two methods
1> select top 1(name) from anuppandey
or
2>select top 5o percent name from anuppandey
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
How to create a testing table with test data in ms sql server?
How to find tables without indexes?
How to grant a permission in ms sql server using "grant execute" statements?
Describe how to use the linked server?
What is meant by dirty read?
What is the cartesian product of table?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
What is the current limitation of the size of SQL Azure DB?
what is difference between NULL and ISNULL in SQL Server 2008?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
Do you know what are the ways available in sql server to execute sql statements?
What have included columns when we talk about sql server indexing?
How many tables can be joined in SQL Server?
Explain what role entity and relationship play in an ER diagram.
What does the not null constraint do?
