Answer / ritesh

select max(salary) from emptable where salary < (select max(salary) from emptable);

Answer / vijayalakshmi

select  top 1 Coumn_Name from (select top 2 Coumn_Name from Table_name order by Coumn_Name desc) b order by Coumn_Name

Answer / abhishekjaiswal

select a.last_name,a.salary from employees a where 3=(select count(*) from employees b where b.salary>a.salary) order by a.salary desc.
<<<<<<<<<[N-1]>>>>>>>>>>

Answer / santosh kumar

select * from(select rownum r,ename,sal from(select * from emp order by sal desc))where r=2;

Difference between an implicit & an explicit cursor.?

2 Answers  

---

List the various oracle database objects?

0 Answers  

---

If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X

2 Answers  

---

Can we create trigger on view in oracle?

1 Answers  

---

Explain drop constraint oracle?

0 Answers  

---

How can you use check constraints for self referential integrity?

0 Answers  

---

What is the difference between online and offline backups?

0 Answers   MCN Solutions,

---

what is Table ?

2 Answers  

---

select * from emp what happened internally when we write this query in the sql prompt?

5 Answers  

---

How to restrict the duplicate records in table valuesets

2 Answers   IBM,

---

Explain the difference between replace() and translate() functions in oracle?

0 Answers  

---

Can you use a commit statement within a database trigger?

4 Answers  

---