To find second largest salary in Employee table
Answers were Sorted based on User's Feedback
Answer / anu
Select max(Sal) from emp
Where
Sal
<
(Select max(Sal) from emp);
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sujith
select empname,salary from(
select empname,salary, rank() over( order by salary desc) ss from emp)
where ss=2;
| Is This Answer Correct ? | 3 Yes | 4 No |
Answer / ela tiku
Select Max(SAL) FROM emp WHERE sal<(SELECT MAX(SAL) FROM
emp)
<<<assuming sal is the column name and emp is the table
name>>>
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / kuduba.r
select max(salary) from emp where sal<(select max(salary)
from emp)
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / anjum
SELECT MAX(SALARY)FROM EMP WHERE SALARY(SELECT MAX(SALARY)
FROM EMP)
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / murugesh
select * from (select row_number over( order by salary
desc) as salcount,empid,salary from employee) emp
where emp.salcount = 2
| Is This Answer Correct ? | 1 Yes | 2 No |
How to verify a login name with sqlcmd tool?
What is checkpoint in sql server?
What is the difference between system objects and user objects?
What is the use of tempdb? What values does it hold?
Explain indexes disadvantages?
Can I save my report as html, excel or word? : sql server management studio
What are the pre-defined functions in the sql server?
What is the difference between having clause and where clause in sql server?
how we use window authentication connection with sql server.?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
what information is maintained within the msdb database? : Sql server administration
logshipping is Any difference 2000 and 2005?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)