SELECT id, name, city, ImageName, ImagePath
FROM aaaa
ORDER BY CASE WHEN ID > 0 THEN
(SELECT MAX(ID)
FROM [dbo].[aaaa]) + 1 ELSE ID END, id DESC
result
id
0
3
2
1
Loading
Sandeep Singh ShekhawatPosted Apr 11, 2013, 11:09 AM
For more detail
http://www.c-sharpcorner.com/UploadFile/3d39b4/case-statement-in-sql/