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
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
What are the advantages of having an index on the sql server?
What are indexes in ms sql server?
What does dml stand for?
Does table partitioning improve performance?
where can you add custom error messages to sql server? : Sql server administration
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
When cursors are useful?
Describe different Processing Modes offered by SSRS?
What is the purpose of linked server configuration in sql server?
What is recompile sql server?
Explain about extended stored procedure?
What is data source view or dsv? : sql server analysis services, ssas
In what version of sql server were synonyms released?
What is a View ? Can we insert, Update and delete a view?