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

How do you open a cluster administrator?

1054

What is table-valued sub query?

973

Can you always create a cache of a report?

172

what are different types of raid configurations? : Sql server database administration

1066

How do I clean up sql server transaction log?

1071

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

964

Define outer join?

1003

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

965

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

976

Explain what is lock escalation?

1071

What is attribute relationships, why we need it? : sql server analysis services, ssas

970

How to send a ssrs report from ssis?

176

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1069

What are the dmvs? : sql server database administration

1065

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1076