Answer Posted / nancy singhal

select max(salary) from emp where salary in(select salary
from emp where salary not in(select max(salary) from emp));

What is a sql select statement?

1082

---

what are string data types? : Sql dba

1092

---

explain mysql aggregate functions. : Sql dba

1028

---

What is trigger types in sql?

1042

---

Which sql statement is used to delete data from a database?

1003

---

Are views faster than queries?

1038

---

How do I filter in sql profiler?

1048

---

what is the use of double ampersand (&&) in sql queries?

1226

---

What do you mean by table in sql?

1045

---

What is sql lookup?

970

---

Differentiate pl/sql and sql?

1128

---

Can you skip header records while loading? : aql loader

1100

---

Difference between truncate, delete and drop commands?

1141

---

Are dml statements autocommit?

1092

---

Does mysql_real_escape_string prevent sql injection?

993

---