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

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

1999

How to perform key word search in tables?

948

What the difference between UNION and UNIONALL?

1022

How do you run a trace?

887

What are window functions in sql server?

982

Can foreign key be deleted?

905

What is sql or structured query language?

1130

How to get all stored procedures in sql server?

980

Mention the differences between local and global temporary tables.

1005

Explain Reporting Life Cycle?

125

What are the joins in sql server? : sql server database administration

992

How is sql used in sql server?

990

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

994

What is update_statistics command?

1047

What is advantage data architect?

905