My Pages

Search This Blog

Wednesday, April 6, 2011

What is an Inline View

The concept of using subquery in the FROM clause of SELECT statement is called inline view

Example:-
 SELECT T1.Col1, T1.Col2, T2.Col1
FROM Table1 T1,(SELECT col1,AVG(col2) FROM Table1 GROUP BY Col2) T2
WHERE T1.Col1 = T2.Col1