hi there, Lets start with Inline View or rather inline query... take a look at example:- /* Select ename,sal from (select ename,sal from emp order by) where rownum < 5. */ here after from there is no table name it is the result of query that is being used this is called inline view or inline query. anyone can throw some light on Sub queries not sure im confident in that
If its green its biology if its stinkks its chemistry if it has numbers it is Maths and if it doesn't work its TECHNOLOGY
Hi there, A subquery as I know it is part of the where clause. A simple example:
As might be obvious most, if not all, subqueries can be reformulated to be simply joins (rather obvious in this example). That is also what a decent optimizer would do. Subqueries do have a use in keeping your SQL readable, certainly when the statements get more complex, I 'd say. Good riddance, Rudy.