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

Answer Posted / ajay

select * from emp where sno between 5 and 7









ajay.thomala@gmail.com

Is This Answer Correct ?    2 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the methods used to protect against sql injection attack?

571


What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

488


What is the sql case statement used for? Explain with an example?

536


on line cluster can we make if yes tell me the procedure

1513


Who is the owner of a schema in ms sql server?

544






How do I find the sql server database version?

525


Explain having clause and where clause?

578


what is the difference between count(*) and count(1) ?

627


How do database indexes work?

542


What is snapshot report?

129


What is use of except clause? How it differs from not in clause?

598


What are the types of indexes?

591


What is reference section?

497


Do comments need to go in a special place in sql server 2005?

509


Can primary key be null?

513