select * from emp where empid >=5 and empid <=7

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

Question Posted / sam

Answer Posted / sam

Is This Answer Correct ?

3 Yes

9 No

Please Help Members By Posting Answers For Below Questions

How to enter binary string literals in ms sql server?

1164

What are the features of Embedded SQL

1130

Why use triggers?

1015

What is the difference between a "where" clause and a "having" clause?

1160

How to add more data to the testing table in ms sql server?

1090

What is difference between inner join and join?

1045

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?

1035

What stored by the model? : sql server database administration

953

How do you set a trace flag in sql server?

1038

What is the function of sql server agent windows service?

1097

What is index, cluster index and nonclustered index?

996

How do I start sql server 2017?

942

How to convert a numeric expression from one data type to another?

1016

Please illustrate physical database architecture? : SQL Server Architecture

988

What is query cost in sql server?

996