select * from (select row_number() over (order by empid) as row, * from

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

Question Posted / smitha

Answer Posted / smitha

select * from (select row_number() over (order by empid) as
row, *
from employee)a
where a.row between 4 and 5

Is This Answer Correct ?

7 Yes

3 No

Please Help Members By Posting Answers For Below Questions

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

980

Where in ms sql server is ’100’ equal to ‘0’?

1017

Mention the different types of replication in sql server.

957

What are the advantages of stored procedure in sql server?

832

What is a primary index?

881

What are types of subqueries?

994

What is normalization and its types?

962

What is t-sql script to take database offline – take database online.

1021

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

923

What is a not null constraint?

974

What is tabulation?

896

What is the difference between DATETIME2 and DATETIME?

1017

What is data mart? : sql server analysis services, ssas

1002

Can you explain important index characteristics?

937

What are basics of policy management?

1048