Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361236 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 / rajkishore bagwan
simplest method ----
select salary
from employees
order by salary desc
offset n-1 rows fetch next 1 rows only
(replace n with any number it will give you the nth highest salary)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain normalization and what are the advantages of it?
What is output spooling in sql*plus?
What are conditional predicates?
what are date and time functions in mysql? : Sql dba
What are the types of triggers in sql?
State few characteristics of pl/sql?
Why is nosql good?
Can we create foreign key without primary key?
What is schema in sql?
what are myisam tables? : Sql dba
what is sql server agent? : Sql dba
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
How many aggregate functions are available there in sql?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
What is the starting oracle error number? What is meant by forward declaration in functions?
