×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: Java
Posted by: sumesh tg
Added: Nov 18, 2016 10:29 AM
Views: 7
Tags: no tags
  1.   query = "SELECT *,CONCAT('task',ticket_no) as ticket FROM task_master ORDER BY (CASE\n"
  2.                             + "    WHEN updated_date  IS NULL THEN created_date\n"
  3.                             + "    ELSE updated_date\n"
  4.                             + "END) DESC ";