how do we find every fifth record in a table
Answer Posted / satya gupt
select salary from emp e where 4=(select count(salary) from
emp where salary>e.salary
Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Where the sql logs gets stored?
How to call a function from a stored procedure in SQL Server ?
Explain the difference between control flow and data flow?
How can you tell if a database object is invalid?
What are the different methods available under sqlcommand class to access the data?
What is local temp table?
How to defragment table indexes?
What are the steps you should follow to start sql server in single-user mode?
Explain steps of normalization?
What causes index fragmentation?
Tell me what are cursors and when they are useful?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
Can sql servers linked to other servers like oracle?
Explain triggers in sql?