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)?
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
What is 3nf normalization form?
What is the difference between for xml raw and for xml auto?
What is difference between unique and primary key?
What is row_number () and partition by in sql server?
What is merge?
How to end a stored procedure properly in ms sql server?
Explain different types of locks in sql server.
What is read committed?
What is dbcc updateusage?
What are the different types of locks in the database?
How to rename databases in ms sql server?
Explain what is scheduled job and how to create it?
What is after dml trigger?
How do you implement session management in SQL Server mode?
How to count rows with the count(*) function in ms sql server?