Subject Nested Select
Author jabangarita
How does Firebird/Interbase nested select work in??

For example: (ACCESS)

SELECT t.risk, COUNT(t.name)
FROM [SELECT t1.name, MAX(t1.risk) as risk
FROM Table1 AS t1
GROUP BY t1.name ]. AS t
GROUP BY t.risk;



Thanks