Answer Posted / raghu munukutla

SQL> select max(sal) from emp where rownum<=(select
count(sal)-1 from emp)
order by sal desc;

What is the difference between rollback and rollback to statements?

1060

---

what is offset-fetch filter in tsql? : Transact sql

948

---

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1014

---

how to drop an existing index in mysql? : Sql dba

1069

---

Why use stored procedures?

1093

---

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

963

---

Can %notfound return null after a fetch?

1060

---

Explain the the delete statements in sql?

1062

---

How show all rows in sql?

1013

---

Explain what is a field in a database and record in a database?

1097

---

what are integrity rules?

1026

---

what are the advantages of sql ? : Sql dba

1060

---

What is linq to sql?

1132

---

How do I save the results of sql query in a file?

978

---

How you improve the performance of sql*loader? : aql loader

1013

---