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 skip remaining statements in a loop block using continue statements?

1041

Why people hate cursor?

1202

What is raid, and how it can influence database performance?

1097

Explain database normalization?

1266

What is the difference between a function and a trigger?

1122

Can you explain important index characteristics?

1030

State the difference between union and union all?

985

How to convert character strings into numeric values?

1144

How connect excel to sql server?

1051

How much memory that we are using in Logshipping Concept?

1842

What is the process of normalization?

1180

List out the differences between global and local temp tables in sql server?

1108

How to insert multiple rows with a subquery?

1186

Explain primary key, foreign key and unique key?

1022

What are the dis_advantages of stored procedures, triggers, indexes?

2273