Hi,

I need help in writing a query in select list, Is this possible in TD. In Oracle we are able to do it. I have a requirement like this:

select col1, col2, Round((col2*100.0/*(select Round((col2*100.0/**(select count(col4) from tableh group by col)),*999.9)
col)),**999.9)
FROM (select col1,count(col2) 
      from tablea, tableb
      Where tablea.col1 = tableb.col1
      and tablea.col2 = tableb.col2
      group by col1)

Thanks in advance. TDHelp

Hi,

I need help in writing a query in select list, Is this possible in TD. In Oracle we are able to do it. I have a requirement like this: select col1, col2, Round((col2*100.0/*(select count(col4) from tableh group by col)),*999.9) FROM (select col1,count(col2) from tablea, tableb Where tablea.col1 = tableb.col1 and tablea.col2 = tableb.col2 group by col1)

Thanks in advance. TDHelp