How do you retrieve the second highest salary from a table?

3 Answers  

---

What are different types of triggers?

0 Answers  

---

i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id.

2 Answers   Oracle,

---

How do you change a value in sql?

0 Answers  

---

What is the life of an sql statement?

0 Answers  

---

What is keys and its types?

0 Answers  

---

When do we use triggers?

0 Answers  

---

How many null values can be inserted in a coulmn whihc is unique constraint

8 Answers   Flextronics,

---

how to calcuate the second highest salary of he employee

13 Answers   Synechron,

---

What is auto increment in sql?

0 Answers  

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

0 Answers  

---

source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?

4 Answers   JPMorgan Chase,

---