how to select 5 to 7 rows from a table, which contains 10 rows?
Answer Posted / priyanka
select top 3 * from emp where id not in
(select top 4 id from emp order by id)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain syntax for viewing trigger?
What are the extra roles available in msdb? : sql server security
What is the difference between for auto and for nested?
What are the system database in sql server 2008?
What is a transactions?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
Explain the rules for designing files and file groups in sql server?
Explain an incremental backup?
What is user-defined functions? What are the types of user-defined functions that can be created?
How to create function with parameter in sql server?
Can you explain what is indexed view? How to create it?
What are policy management terms?
What is the difference between seek predicate and predicate?
Why use identity in sql server?
How to scale out a federation by Sql statement?