Subject | SQL Problem |
---|---|
Author | Leandro Sinhorini Alves |
Post date | 2004-06-18T04:08:25Z |
I have this two sql's, one in mySQL dialect other in Oracle dialect:
MYSQL: select count(distinct x, y) from t
ORACLE: select count(*) from (select distinct x, y from t)
I need a equivalent select that works in Firebird, and it have to be in one select. It´s possible?
Leandro
[Non-text portions of this message have been removed]
MYSQL: select count(distinct x, y) from t
ORACLE: select count(*) from (select distinct x, y from t)
I need a equivalent select that works in Firebird, and it have to be in one select. It´s possible?
Leandro
[Non-text portions of this message have been removed]