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

What is the purpose of grouping data in a report?

942

What is the use of @@spid?

983

What are system databases in ms sql server?

1025

When do you think a developer should use sql server-based cursors?

1021

How to end a stored procedure properly in ms sql server?

1066

What are the diifferences between the ms sql server vs mysql?

1157

What do you mean by authentication modes in sql server?

1066

How to install sql server 2005 express edition?

1098

What is buffer cash and log cache in sql server?

1094

What is database dimension? : sql server analysis services, ssas

1064

What is database black box testing?

1017

What happens if null values are involved in bitwise operations?

994

What are the approximate numeric data types?

910

Explain index in sql server?

996

How to create a view on an existing table in ms sql server?

1106