Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368287 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / shiva
select salary from table_name where salary <(select salary
from table_name);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is composite data type in pl sql?
How to make a copy values from one column to another in sql?
What is java sql drivermanager?
Can we commit inside a trigger?
Is hadoop a nosql?
Can we perform dml in function?
Explain the advantages and disadvantages of stored procedure?
Write a sql query to convert all character to uppercase after hypen.
What is view explain with example?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
How do you use a while loop in pl sql?
What is the maximum number of columns in sql table?
How to Declare Fixed Length String Value In PL SQL
Can a table have no primary key?
What is the sql query to display the current date?
