SELECT * from emp_table WHERE e_id>=5 AND e

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

Question Posted / kaviraj.y

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

Answer Posted / kaviraj.y

SELECT * from emp_table WHERE e_id>=5 AND e_id<=7;

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Define left outer join in sql server joins?

964

How to create a view using data from another view?

950

Name three of the features managed by the surface area configuration tool? : sql server security

992

What is replace and stuff function in sql server?

1067

What are the advantages of the mirroring?

1094

What are exact numeric data types in ms sql server?

1077

Can we use where and having clause together?

1045

You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

121

Do you know what is difference between index seek vs. Index scan?

954

What are the differences between union, intersect, and minus operators?

1086

What is a linked server in sql server?

1076

What is 3nf normalization?

996

Why is sql server log file full?

1039

Explain what is “asynchronous” communication in sql server service broker?

917

What are trace flags and mention a few common trace flags used with sql server?

1087