Answer Posted / vijay shegokar

select * from employee where salary=(select max(salary) from
employee where salary not in (select max(salary) from
employee));

What are sql built in functions?

893

---

What are % type and % rowtype?

977

---

How to select all records from the table?

1066

---

What is rownum in sql?

962

---

What is a temp table?

948

---

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1070

---

How would you convert date into julian date format?

946

---

What is procedure function?

981

---

What is a field in a database?

1002

---

How do I clear the screen in sql plus?

979

---

What is cost in sql execution plan?

897

---

Mention what is the plv (pl/vision) package offers?

1055

---

what is bcp? When is it used?

1042

---

What does cursor do in sql?

969

---

How can I delete duplicate rows?

963

---