How about:
Which should only count(*) one of the tables.Code:SELECT CASE WHEN NVL((SELECT 1 FROM t WHERE rownum = 1), 0) = 1 THEN (SELECT count(*) FROM t) ELSE (SELECT count(*) FROM t1) END FROM dual
TTFN
John
|
Results 1 to 6 of 6
Thread: problem in queryThreaded View
|
Click Here to Expand Forum to Full Width |