Post reply

Order By Clause

  • September 8, 2011 at 8:25 am

    #1378573

    I agree.. Never would have put the Order by in the sub because I don't see the reason too. So I would have never learn it would fail until now

  • September 13, 2011 at 5:22 am

    #1380503

    Really had to think through this one. Thanks for a tough question of the day.

    http://brittcluff.blogspot.com/

  • November 1, 2011 at 1:55 am

    #1401441

    3rd will also fail since ambiguous column with order by.

  • May 31, 2012 at 2:13 am

    #1495042

    Query 3 would fail because both tables contain employee id column but, alias name of employee id have not been used in order by clause. Please check for the Query 3 and revert back.

  • June 3, 2012 at 7:12 am

    #1496281

    Nandhini Ramanujam (5/31/2012)

    Query 3 would fail because both tables contain employee id column but, alias name of employee id have not been used in order by clause. Please check for the Query 3 and revert back.

    Query 3 does not fail. if there is more than one EmployeeID column, the ORDER BY clause uses the one that is in the select statement. There is only one in the select statement so the query executes just fine.

  • January 24, 2013 at 9:30 pm

    #1580806

    very nicw question..i got it wrong though:-D

Viewing 6 posts - 46 through 50 (of 50 total)

You must be logged in to reply to this topic. Login to reply