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 the purpose of grouping data in a report?
What is the use of @@spid?
What are system databases in ms sql server?
When do you think a developer should use sql server-based cursors?
How to end a stored procedure properly in ms sql server?
What are the diifferences between the ms sql server vs mysql?
What do you mean by authentication modes in sql server?
How to install sql server 2005 express edition?
What is buffer cash and log cache in sql server?
What is database dimension? : sql server analysis services, ssas
What is database black box testing?
What happens if null values are involved in bitwise operations?
What are the approximate numeric data types?
Explain index in sql server?
How to create a view on an existing table in ms sql server?