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

State the difference between local and global temporary tables?

1051

What are the rules to use the rowguidcol property to define a globally unique identifier column?

966

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

959

What programming language would you use to create embedded functions in ssrs?

172

Explain filtered indexes benefits?

954

What is the syntax for encrypting a column in SQL Server?

1060

What does the on update no action do?

965

What is temporary stored procedure?

898

Do you know what is a with(nolock)?

1000

What are the different authentication modes in sql server? How can it be changed?

1026

How do you delete duplicate records in sql server?

996

What is 2nf example?

943

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1006

How to convert a unicode strings to non-unicode strings?

1031

What is query and its types?

875