Answer Posted / gurvinder

select max(sal)from emp where sal in(select sal from emp minus select max(sal) from emp);

What is information schema in sql?

1118

---

How do I run a pl sql procedure in sql developer?

1022

---

What is scalar and vector?

1062

---

How to get unique records from a table?

1024

---

what is a tablespace? : Sql dba

1102

---

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

1228

---

What are the 3 modes of parameter?

1208

---

Can we create foreign key without primary key?

1040

---

Explain locks? : Transact sql

1058

---

How do you declare a user-defined exception?

1076

---

What do you understand by case manipulation functions?

1081

---

What operators deal with null?

1156

---

how to include comments in sql statements? : Sql dba

999

---

What packages(if any) has oracle provided for use by developers?

5883

---

What is linq to sql?

1180

---