Wednesday, January 25, 2012

sqlchallenge 2

id           Bookname
----------------------
1           GlobleWorld
2           Tunner
3           Roster in city
4          GNom
5          Three mistake
6          other,Not specified
7          The Secret
8          inspiration

give result order by bookname but last row must be a "other,Not specified"
like this

-------------------------------------------------------------------------

id           Bookname
----------------------
1           GlobleWorld
4           GNom 
8           inspiration 
3           Roster in city 
7          The Secret  
5          Three mistake
2           Tunner
6          other,Not specified
Posted by at
Labels:

1 comment:

  1. Naimish RavraniFebruary 7, 2012 at 8:44 PM

    SELECT *,ROW_NUMBER() over(order by Bookname)as rnk,
    FROM Tablename
    where ID not in(select id from Tablename where Bookname = 'other,Not specified')
    union all
    select * , '' from Tablename
    where ID in(select id from Tablename where Bookname = 'other,Not specified')

    ReplyDelete

Subscribe to: Post Comments (Atom)