Answer Posted / thananjayan

SELECT * FROM 'emp` WHERE salary < ( SELECT max( salary
)FROM emp ) ORDER BY salary DESC LIMIT 1

This is Mysql syntax, if you use Oracle just remove LIMIT 1
and put it ROWNUM=1;

What is the difference between a user and a schema in oracle?

1035

---

What are the limitations oracle database 10g xe?

1048

---

Why should I use oracle database?

1000

---

How to drop a stored function?

1140

---

Can multiple cursors being opened at the same time?

1066

---

What is a lookup table in oracle?

975

---

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1995

---

material view and view disadvantages?

1079

---

How to install oracle database 10g xe?

1024

---

How do I escape a reserved word in oracle?

1203

---

How will you differentiate between varchar & varchar2?

1048

---

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2559

---

Difference between pre-select and pre-query

1115

---

What is an external table?

1028

---

Can you create a synonym without having a table?

1046

---