Answer Posted / suresh

select sal from emp e
where 100=(select count( distinct sal) from emp where
e.sal<=sal)

what is sql in mysql? : Sql dba

1120

---

What is the purpose of normalization?

995

---

How to check if a column is nullable before setting to nullable?

1054

---

how is exception handling handled in mysql? : Sql dba

1006

---

When can we use the where clause and the having clause?

966

---

Can a select statement fire a trigger?

1096

---

Does truncate require commit?

918

---

What is clustered index in sql?

1000

---

What steps server process has to take to execute an update statement?

919

---

What is the usage of nvl function?

981

---

What is dense_rank in sql?

915

---

what is a unique key ? : Sql dba

1024

---

Can we use join in subquery?

1022

---

Can we use threading in pl/sql?

970

---

Is a view faster than a stored procedure?

899

---