select * from emp where sno between 5 and 7 ajay.thomala

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

Question Posted / ajay

Answer Posted / ajay

select * from emp where sno between 5 and 7

ajay.thomala@gmail.com

Is This Answer Correct ?

2 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Explain identity in sql server?

988

Is null in sql server?

968

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1049

how can a database be repaired? : Sql server administration

955

what changed between the previous version of sql server and the current version? : Sql server database administration

985

Define clusters?

1035

which backup strategy you are following at ur company

2132

You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

153

What is implicit mode in sql server?

1074

Explain what is analysis service repository?

967

What are the steps you will take to improve the performance of a poor performing query?

957

How do I open port 1433?

915

What are the differences between clustered and non-clustered index?

1003

Explain error handling in ssis?

999

how can you attach more than 20 ldf files in sql server

1983