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

Answer Posted / sam

select * from emp where empid >=5 and empid <=7

Is This Answer Correct ?    3 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is primary key, unique key, and foreign key?

537


What is data source object?

549


How to find the second highest salary of an employee?

588


Do you know what are the reporting services components?

529


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

515






Explain how many types of relationship?

573


How to specify the collation for a character data type in ms sql server?

552


What do you mean by the term 'normalization'?

666


How to delete an existing row with delete statements in ms sql server?

550


What are out-of-range errors with date and time literals?

554


Explain few examples of stored procedure over triggers?

519


What are the two authentication modes in sql server?

600


Can you move the resources after pausing the node? : sql server database administration

596


If we delete pack Spec what will be the status of pack Body ?

966


Explain the difference between control flow and data flow?

527