Answer Posted / arun

select salary from(select salary from(select distinct salary from employees order by salary desc) where rownum<=2 order by salary) where rownum=1;

What is sql character function?

996

---

How is pl sql different from sql?

1015

---

How to revise and re-run the last sql command?

1102

---

Is merge a dml statement?

924

---

What is the requirement of self-join?

1027

---

What are the set operators in sql?

1032

---

Can a table have no primary key?

1011

---

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1017

---

What is a sql select statement?

996

---

i have some prob lem to tell me about my self in interview first round ...

2116

---

what is a control file ? : Sql dba

991

---

How to start the command-line sql*plus?

1002

---

Can ddl statements be used in pl/sql?

1070

---

explain access control lists. : Sql dba

949

---

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1161

---