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
25226 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

List few advantages of stored procedure.

924

List all the types of user-defined functions?

991

How to modify an existing user defined function?

1032

Define candidate key, alternate key, and composite key.

871

Difference between drill down and drill through report.

900

What is the use of commit?

954

Can we use pragma autonomous_transaction in trigger?

910

How to use copy and concatenate commands in SQL?

1064

How check triggers in sql server?

914

What are constraints?

958

How to transfer data from a cursor to variables with a "fetch" statement?

1020

What are the security related catalog views? : sql server security

912

How do I find sql server instance name?

914

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?

954

How to Insert multiple rows with a single insert statement?

1000