Hello friends!!
I need help.....
I have view which gives me records for student result like
create view result
as
select ...some column name , maths,english
from
( select some column name,
case subject_name when maths then maths + 10 maths,
case subject_name when english then english + 10 english from tableX
) P
Like that actually subject_name i m getting from different tableX...but in future that records may increase as subject increase..now the data i m getting is static data from that perticular tableX..but i want flexible data like select subject_name from that perticular tableX...
so is that any query that will give me...as records will increase in tableX that will appear in first select list