Interested to Buy Any Domain ? << Click Here >> for more details...
To find second largest salary in Employee table
- 17 Answers
- 19774 Views
- CSS, I also Faced
- E-Mail Answers
Answer Posted / mohammad murtuza ali
select salary from employeetable where empsal is < max(salary)
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What are the dmvs? : sql server database administration
What is the data type of time?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is an identity column in insert statements?
What information is maintained within the msdb database?
How to test subquery results with the exists operator?
How to use values from other tables in update statements in ms sql server?
What is normalization and its types?
How except clause is differs from not in clause?
can SSRS reports Cache results?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
what are the different stages of Report Processing?
How would you choose between a clustered and a non-clustered index?
What is the security principal at the database level that represents your session?
