select * from emp where empid between 5 and 7

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

Question Posted / govind

Answer Posted / govind

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the difference between getdate and sysdatetime?

940

Explain the ways to controlling cursor behavior?

871

Does partitioning improve performance?

916

Explain intellisense for query editing

977

What is serializable?

995

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

962

Can a cursor be updated? If yes, how you can protect which columns are updated?

1029

What are subqueries in sql server? Explain its properties.

964

what's the maximum size of a row? : Sql server database administration

1012

Where cross join is used?

903

What are the differences between DDL, DML and DCL in SQL?

1169

Explain Geometry datatype in sql server 2008 with example

918

What is use of attributehierarchyenabled? : sql server analysis services, ssas

1160

What are types of scd? : sql server analysis services, ssas

972

Why use “pivot” in sql server?

1041