Interested to Buy Any Domain ? << Click Here >> for more details...
can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 32378 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / swapnl
select max(sal) from emp_det where sal not in (
select max(sal) from emp_det);
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Will the writetext statement activate a trigger?
What is cached report?
How to find out the list schema name and table name for the database?
What is the purpose of linked server configuration in sql server?
How to create dbo table in sql server?
Can you get second highest salary from the table?
Can we take the full database backup in log shipping?
What are types of subqueries?
Can sql servers link to other servers like oracle?
What are the advantages of user-defined functions over stored procedures in sql server?
what's the difference between delete table and truncate table commands? : Sql server database administration
What are the 2 types of classifications of constraints in the sql server?
how many type of indexing in database?
How to add code to the existing article (using improve article)?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
