To find second largest salary in Employee table
Answer Posted / chitharthan
select max(salary)-1 from employeetable
| Is This Answer Correct ? | 0 Yes | 10 No |
Post New Answer View All Answers
Is sql server a database?
What is user-defined function?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
How to create a new schema in a database?
Do you know how to send email from database?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is the use of partition by in sql server?
What is cross join in sql server joins?
How to delete a login name in ms sql server?
What is the use of keyword with encryption. Create a store procedure with encryption?
What do you understand by mirroring?
Explain primary key?
Why use “in” clause in sql server?
What is the difference between delete and truncate statements?
What is meant by referential integrity?