how to find the first two highest salaries in deptno in emp
table
Answers were Sorted based on User's Feedback
Answer / santhosh kandula
if u want select the second highest salary from the emp
table then u have to write query as
select max(salary) from emp where
salary < ( select max(salary) from emp )
| Is This Answer Correct ? | 6 Yes | 1 No |
Explain about the relational database?
What is a self join? Explain it with an example?
Given an employee table, how would you find out the second highest salary?
I have a few records all are same structures data, I want to store data in multiple targets how
0 Answers CTR, Infosys, Polaris,
Explain about network model?
Write short notes on XSU and JAVA
What is the maximum length of an extended property?
Explain the process of the user request and data generating?
explain detail about ftp in datastage?
Explain about a primary key?
Write the fastest query to find out how many rows exist in a table?
What is normalization? Explain different levels of normalization?
8 Answers CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,
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)