how can i use "order by" with empty values
In SQL server, if record have empty value wills display firts, i need display empty value at last
please help me, thanks
use following query...
Select Value1, Value2,Value3 From table
Order By Case When Value1 is Null or Value1 = '' Then 1 Else 0 End, Value1
No comments:
Post a Comment