Example :-
SELECT FirstName,LastName,DepartmentName FROM dbo.Tbl_Employee
ORDER BY
CASE DepartmentName WHEN 'EDP' THEN FirstName ELSE LastName END;
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment