AllInWorld99 provides a reference manual covering many aspects of web programming, including technologies such as HTML, XHTML, CSS, XML, JavaScript, PHP, ASP, SQL,FLASH, jQuery, java, for loop, switch case, if, if else, for...of, for...in, for...each,while loop, blogger tips, blogger meta tag generator, blogger tricks, blogger pagination, client side script, html code editor, javascript editor with instant output, css editor, online html editor, materialize css tutorial, materialize css dropdown list,break, continue statement, label,array, json, get day and month dropdown list using c# code, CSS button,protect cd or pendrive from virus, cordova, android example, html and css to make android app, html code play,telerik show hide column, Transparent image convertor, copy to clipboard using javascript without using any swf file, simple animation using css, SQL etc. AllInWorld99 presents thousands of code examples (accompanied with source code) which can be copied/downloaded independantly. By using the online editor provided,readers can edit the examples and execute the code experimentally.


     If you are using the distinct in SQL query, it will remove the duplicate rows and sort by the name ascending order. So we can't get the actual sorted value. So you can use the following methods.


declare @source table (id int not null identity primary key, name nvarchar(3));
insert into @source
values    ( 'C1' )
        , ( 'B1' )
        , ( 'X1' )
        , ( 'A1' )
        , ( 'B1' )
        , ( 'C1' )
        , ( 'B1' )
        , ( 'A1' )
        , ( 'X1' )
        , ( 'C1' )
        , ( 'D1' )
;
with grouped as
(
    select min(id) as minId, name from @source
    group by name
)
select name from grouped order by minId;

Output
C1
B1
X1
A1
D1


0 comments:

Post a Comment

Total Pageviews