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
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
No comments:
Post a Comment