Interested to Buy Any Domain ? << Click Here >> for more details...
To find second largest salary in Employee table
- 17 Answers
- 20393 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
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
What is extended stored procedures?
What is the difference between char, varchar and nvarchar?
what are different types of backups available in sql server? : Sql server database administration
What is the guest user account in sql server? What login is it mapped to it? : sql server security
Can you please explain the difference between function and stored procedure?
Is it ok to shrink transaction log?
Differentiate between mongodb vs. Sql server?
Define views.
Your table has a large character field there are queries that use this field in their search clause what should you do?
How do I find sql server instance name?
What do you mean by sql server agent?
Explain triggers in sql?
What are the types of processing and explain each? : sql server analysis services, ssas
What sql server means?
