AVADHESH

• Sep 30th, 2011

Code
SELECT newsid, news,STATUS,
                case STATUS
         WHEN '1' THEN 'Active'
          WHEN '0' THEN 'Deactive'
        END AS fieldnm
FROM news ORDER BY newsid;

sirisha.hari

 Profile Answers by sirisha.hari Questions by sirisha.hari

• Jan 6th, 2008

  hi,select sno,sname,(case  when total>50then 'good'when total>35 and total<50then 'average'else   'fail'end)resultfrom student_result

Answer Question  Select Best Answer

A subquery within a subquery

velur1

 Profile Answers by velur1 Questions by velur1

• Sep 19th, 2008

A query within a subquery

rjk1203

 Profile Answers by rjk1203 Questions by rjk1203

• Sep 19th, 2008

A Correlated Subquery which executes with value returned by the child Query. Unlike subquery it executes per result from child query.Ex: removing duplicate rows from a table Subquery executes once for the entire child query's result

Answer Question  Select Best Answer