Hi,
I can also make my query according to my customization order called Custom Order .It works as i want in which order my out will show .As simple as it is...
SELECT COUNT(*)StudentCount,SessionCode FROM dbo.tblStudentNEDESROLL GROUP BY SessionCode ORDER BY CASE
WHEN SessionCode = '0110' THEN 1
WHEN SessionCode = '0710' THEN 2
WHEN SessionCode = '0111' THEN 3
WHEN SessionCode = '0711' THEN 4
WHEN SessionCode = '0112' THEN 5
END
No comments:
Post a Comment