使用子查询,如果需要添加
FROM DUAL:
SELECt (SELECT COUNT(*) FROM TABLE1) As Table1Count, (SELECt COUNT(*) FROM TABLE2) As Table2Count[FROM DUAL]

使用子查询,如果需要添加
FROM DUAL:
SELECt (SELECT COUNT(*) FROM TABLE1) As Table1Count, (SELECt COUNT(*) FROM TABLE2) As Table2Count[FROM DUAL]