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
What is a select query statement in ms sql server?
What is sql server database?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What you can do to delete a table without the delete trigger firing?
What are scalar functions in sql?
How to create an inline table-valued function?
What is conditional split?
How will you add a dimension to cube? : sql server analysis services, ssas
Tell me in brief how sql server enhances scalability of the database system?
Can we use max in where clause?
How to list all schemas in a database?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
What is entity data services?
How to provide login information for a new odbc dsn?
Can the “if update (colname)” statement be used in a delete trigger?