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
- 23436 Views
- Accenture, IBM, Marlabs, I also Faced
- E-Mail Answers
Answer Posted / murthy
declare @n int
set @n=5
select top (@n) * from employees
except
select top (@n-1) * from employees
GO
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
Explain what are the events recorded in a transaction log?
Why does sql studio use a single registered database repository? : sql server management studio
Write an SQL query to obtain the 2nd highest salary.
What is a view and what are its advantages?
How do I create a partition table in sql server?
What are the purpose of Normalisation?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
Which are the two editions in which SQL Azure database available?
What are the advantages of stored procedure in sql server?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
Please differentiate between a local and a global temporary table?
What is a database in ms sql server?
Can we use where clause in union?
What is scalar user-defined function?
