select top 3* from Tablename where columnname in ( select top 7columnname

how to select 5 to 7 rows from a table, which contains 10 rows?

Question Posted / purabi roy(sarkar)

21 Answers
26364 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / purabi roy(sarkar)

select top 3* from Tablename
where columnname in ( select top 7columnname from table
name order by columnname desc )
and columnname not in( select top 4columnname from
tablename order by columnname desc )
order by columnname desc

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between stored procedure and functions?

1064

What is Command line parameters in PLSQL.?

1062

What are Spatial data types in SQL Server 2008

968

What is trigger explain with program?

934

What is the difference between Clustered and Non-Clustered Index?

1014

Can a trigger be created on a view?

897

Do you know the policy based administration feature of sql server 2008?

908

What do you mean by an execution plan?

1055

Explain what are the authentication modes in sql server?

950

What gets stored inside msdb database?

1197

What is an example of a foreign key?

930

What is SubQuery in SQL Server 2008

966

What is a virtual table in sql?

944

Explain atomicity?

974

Explain few examples of stored procedure over triggers?

964