Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 26288 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 standby servers? Explain types of standby servers.
What do you understand by a view?
How to use subqueries with the in operators in ms sql server?
What is difference between inner join and full join?
What is user-defined inline table-valued function?
What are the differences between left join and inner join in sql server?
How to perform backup for certificates in sql server? : sql server security
What are the differences between union, intersect, and minus operators?
What to check if a User database is locked?
What are the advantages of user-defined functions over stored procedures in sql server?
How do I start sql server 2016?
What are page splits?
How to drop an existing table?
How data can be copied from one table to another table?
What are pessimistic lock and optimistic lock?
