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
- 21665 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
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
Explain about local stored procedure?
Can you name a few encryption mechanisms in sql server?
Which language rdl files made of?
Explain what is “asynchronous” communication in sql server service broker?
What is SQL Azure?
What new changes are being made in SQL Server?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
We need to perform what steps in the following order to work with a cursor?
How can we remove orphan records from a table?
How to connect of datebase with sql express.?
What are the disadvantages of using querystrings to send data from one page to another?
what is normalization? Explain different levels of normalization? : Sql server database administration
How to generate random numbers with the rand() function in ms sql server?
What is an indexed view?
