Subject | Nested Select |
---|---|
Author | jabangarita |
Post date | 2004-11-04T15:42:40Z |
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
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