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
explain the storage models of olap? : Sql server database administration
What is checkpoint in sql server?
Why and when do stored procedure recompile?
Explain about service Broker functions?
How to use clusters?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
What are audit control procedures?
What is the downside of using udf?
Tell me what is de-normalization and what are some of the examples of it?
What is the difference between mysql and sql server?
What are parameterized reports?
What is primary key index?
How many types of subqueries are there in sql server?
What are distributed partitioned views?
How to test values returned by a subquery with the in operator?