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

Answer Posted / kaviraj.y

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Describe how to use the linked server?

1066

What is the contrast between sql and pl/sql?

1077

What is the default fill factor value?

1013

Explain Normalization and DE normalization

1055

Does partitioning help performance?

891

What is Command line parameters in PLSQL.?

1062

Why I am getting this error when dropping a database in ms sql server?

1025

What is thr feature of change data capture?

920

How to apply cascading referential integrity in place of triggers?

971

is there a column to which a default can't be bound? : Sql server database administration

969

How do triggers work?

882

How to provide column names in insert statements in ms sql server?

1075

How to create a new login name in ms sql server?

997

How to update multiple rows with one update statement in ms sql server?

1137

Explain forward - only cursors?

986