Answer Posted / debasish

select ename,sal from (select ename,sal,row_number()
over(order by sal desc)rn from emp)
where rn=1;

Why having clause is used in sql?

978

---

What is meant by cursor in sql?

988

---

What is difference between ms sql and mysql?

959

---

What is a unique key and primary key and foreign key?

969

---

what are integrity rules?

1022

---

What are the events on which a database trigger can be based?

1182

---

What are inner outer left and right joins in sql?

1011

---

what are properties of a transaction? : Sql dba

1092

---

What is sql in oracle?

1061

---

What is cte sql?

989

---

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1204

---

What are all the different normalizations?

1025

---

Does view store data in sql?

962

---

What version is sql?

1023

---

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1013

---