Hi, I've a query
Select * from (with x as (select c.a1,c.a2......from t1,t2 where t1.id = t2.id)
select y.s1,
y.s2
.
.
from (select n.d1,n.d2 from n) y
where clause for query1)
UNION
Select * from (with x as (select c.a1,c.a2......from t1,t2 where t1.id = t2.id)
select y.s1,
y.s2
.
.
from (select n.d1,n.d2 from n) y
where clause for query2)
UNION
Select * from (with x as (select c.a1,c.a2......from t1,t2 where t1.id = t2.id)
select y.s1,
y.s2
.
.
from (select n.d1,n.d2 from n) y
where clause for query3)
Hi, I've a query
Here except where clause query criteria is same for all those queries Is there any simple way to write this query without repeating query criteria thrice. Thanks, Kiran
Here except where clause, query criteria is same for all those queries.
Is there any simple way to write this query without repeating query criteria thrice.
Thanks,
Kiran