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
- 23390 Views
- Accenture, IBM, Marlabs, I also Faced
- E-Mail Answers
Answer Posted / uma
all the answers are wrong,the questions is like this there
are 100 rows they want o/p to display is in betwwen 50 and
100 are displayed
select top 100 * from tablename where empid not in(
select top 50 empid from TABLENAME)
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is rtm version in sql server?
How can we check the sql server version?
explain different types of cursors? : Sql server database administration
How do I view a stored procedure in sql server query?
What methods do you follow to protect from sql injection attack?
Can you explain what are various ways to enhance the ssrs report?
Why do we need normalization?
How to resolve the orphan use problem? : sql server security
What are tables in sql server?
What does <> symbol mean?
What do you understand by user-defined function in the sql server?
can any body tell me how to know the password of current user in sql server
What do you understand by coalesce in sql server?
How to query multiple tables jointly?
What are the restrictions that views have to follow? : SQL Server Architecture
