How to arrange date in week wise like from Monday to Sunday?

madhupriya.nukala

 Profile Answers by madhupriya.nukala Questions by madhupriya.nukala

• Jun 26th, 2008

 SELECT TO_CHAR(hiredate,'DAY') FROM emp ORDER BY to_char(hiredate-1,'D');

jannaat

 Profile Answers by jannaat Questions by jannaat

• Apr 28th, 2008

Consider there is table H and you have 3 columns  name week  date so sql statement is select   name ,week,date from  H group by week order by date

Answer Question  Select Best Answer