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
What happens if you add a new index to large table?
How can we get count of the number of records in a table?
What type of Index will get created after executing the above statement?
What is collation sensitivity?
Can sub report data source be different from that of the parent report?
What is a collation?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
How will you optimize a stored procedure optimization?
What is the difference between drop table and truncate table?
what's new in sql server 2016?
What are the advantages of user defined function?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
How to rebuild master databse?