Answer Posted / debasish

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

What is the difference between numeric and autonumber?

1004

---

What is the difference between the implicit and explicit cursors?

1057

---

Is sql an operating system?

1021

---

What program will open a mdb file?

970

---

What is pl sql and why it is used for?

1114

---

How many joins in sql?

1017

---

how to include numeric values in sql statements? : Sql dba

1104

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1089

---

What is the best sql course?

989

---

Explain architecture of sql server notification services?

1065

---

What is the purpose of cursors in pl/sql?

1138

---

What is over () in sql?

970

---

How does cross join work?

961

---

What is your daily office routine?

2274

---

what are integrity rules?

1036

---