Select Query with distinct and order by. : The Official Microsoft ASP.NET Forums

ASP.NET

Complete Thread

- Reply
Twinkle1989

Member

297 Points

131 Posts

Re: Select Query with distinct and order by.

Apr 13, 2012 05:07 AM|LINK

here write some written mistake but actually not run

select reference_no from table_name
order by substring(reference_no,17,4) it's work well reference_no like DAR/EXP/FCL/2012-0051

select distinct reference_no from table_name
order by substring(reference_no,17,4) it's show error reference_no like DAR/EXP/FCL/2012-0051

Remember to click “Mark as Answer” on the post, if it helps you.
Twinkle Arora (India)
- Edited by Twinkle1989 on Apr 13, 2012 05:08 AM