Answer Posted / rameshwari

select ename,esal from
(select ename,esal from hsal
order by esal desc)
where rownum <=2;

How do I tune a sql query?

1043

---

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1126

---

how to get @@error and @@rowcount at the same time? : Sql dba

1082

---

Why select is used in sql?

1070

---

What is 19 null in sql?

1023

---

Explian rowid, rownum?

1086

---

how to create a new table by selecting rows from another table in mysql? : Sql dba

1168

---

What is oracle and pl sql?

1160

---

What is a schema? How is it useful in sql servers?

1178

---

What is pessimistic concurrency control? : Transact sql

1136

---

Can we perform dml on view?

1118

---

What are pl sql procedures?

1081

---

How to execute a stored procedure?

1162

---

What is #table in sql?

1182

---

What is difference between stored procedures and application procedures?

1068

---