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
26253 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 happens if the update subquery returns multiple rows in ms sql server?

1169

How to use go command in "sqlcmd"?

1264

Explain comment on transactions?

1041

How can we call UDF(User Define Function) using C# code in ASP.net ?

6947

What are indexers?

1134

Why union all is faster than union?

977

What happens if date-only values are provided as date and time literals?

1077

How many types of database relationship in sql server?

1101

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1104

Can we call future method from queueable?

1097

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

127

What is an etl file?

1008

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1180

what is a self join? Explain it with an example? : Sql server database administration

1002

How to convert binary strings into integers in ms sql server?

1080