Interested to Buy Any Domain ? << Click Here >> for more details...
To find second largest salary in Employee table
- 17 Answers
- 20873 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
Will sql server 2005 allow you to reduce the size of a column?
What are dml triggers and types of dml triggers?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
How do I open port 1433?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What is model database? : SQL Server Architecture
What are sparse columns?
How to delete exactly duplicate records from a table?
What is SQL Azure Fabric?
List out the difference between union and union all in sql server?
what are isolation levels? : Sql server database administration
What is the difference between stored procedure and functions?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is log cache in sql server?
What is data source object?
