Answer Posted / suresh.pathuri

It is the select stataement in the from clause of the another select statement .it used simplyfy the complex queries and removing the many join operations on the table.
this type
select * from(select rownum from emp order by rownum desc) suresh where rownum<=5;

How can you save or place your msg in a table?

953

---

How would you pass hints to the sql processor?

920

---

What does closing a cursor do?

1244

---

What are sql indexes?

934

---

what are the 'mysql' command line options? : Sql dba

1016

---

What is the use of function in sql?

1028

---

Can we use join in subquery?

1022

---

What is sql query limit?

911

---

What are the qualities of 2nf?

975

---

Is oracle sql free?

927

---

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

994

---

How to display the records between two range in Oracle SQL Plus?

1098

---

What does over partition by mean in sql?

919

---

What is an exception in PL/SQL? What are the two types of exceptions?

1193

---

how are mysql timestamps seen to a user? : Sql dba

1048

---