declare @n int set @n=5 select top (@n) * from employees except select

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)?

Question Posted / murthy

16 Answers
26304 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

Please Help Members By Posting Answers For Below Questions

explain the storage models of olap? : Sql server database administration

1018

What is checkpoint in sql server?

1218

Why and when do stored procedure recompile?

1033

Explain about service Broker functions?

1089

How to use clusters?

1021

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.

3925

What are audit control procedures?

1039

What is the downside of using udf?

1168

Tell me what is de-normalization and what are some of the examples of it?

1103

What is the difference between mysql and sql server?

1095

What are parameterized reports?

205

What is primary key index?

1019

How many types of subqueries are there in sql server?

1040

What are distributed partitioned views?

1137

How to test values returned by a subquery with the in operator?

1258