<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Sajeev SL
»
Sort Order - Include Null al last
139 posts, Page 2 of 14
««
1
2
3
4
5
»
»»
Sort Order - Include Null al last
Rate Topic
Display Mode
Topic Options
Author
Message
Manie Verster
Manie Verster
Posted Monday, June 23, 2008 12:24 AM
Ten Centuries
Group: General Forum Members
Last Login: Monday, May 20, 2013 3:00 AM
Points: 1,151,
Visits: 879
As far as I know, if you use isnull then the field, when null will take the value presented in the isnull, that means that question 2 must be right. Heck, can 98% people have it wrong. Shucks.........
Manie Verster
Developer
Johannesburg
South Africa
Life is about choices.... I choose to be happy today
Post #521545
Asim Arif
Asim Arif
Posted Monday, June 23, 2008 12:51 AM
SSCrazy
Group: General Forum Members
Last Login: Tuesday, February 26, 2013 3:55 AM
Points: 2,039,
Visits: 29
I made the right choice that is #2 but it says that I'm wrong??
Please correct it please.
Post #521548
spaghettidba
spaghettidba
Posted Monday, June 23, 2008 1:43 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Today @ 7:05 AM
Points: 4,804,
Visits: 8,069
Really funny! I've been a member since 2002 and I've never answered qod before: I answered two questions in the last ten days and both were wrong!
There's something wrong with me, maybe...
Get your two-cent-answer quickly
The Spaghetti DBA
Post #521568
Daniel van Wyk
Daniel van Wyk
Posted Monday, June 23, 2008 1:58 AM
SSC Rookie
Group: General Forum Members
Last Login: Wednesday, June 08, 2011 12:54 PM
Points: 29,
Visits: 32
I also chose option 2 and was told that it's not correct.
It seems that the "answer" is both options 2 and 3, which is incorrect. option 3 does not result in the sample output given the sample input.
According to the explanation of the answer only option 2 is correct.
This is my first time answering a question of the day, but clearly there seems to be something wrong here. What's going on with this question?
Post #521574
Biggles-581128
Biggles-581128
Posted Monday, June 23, 2008 2:26 AM
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, July 13, 2011 2:21 AM
Points: 251,
Visits: 208
:D
Seems the author fell into the trap the question was trying to highlight. Only option 2 gives the required result!!
Post #521580
Philip Barry
Philip Barry
Posted Monday, June 23, 2008 2:56 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, April 04, 2013 4:54 AM
Points: 1,383,
Visits: 520
I selected option 2 (and only option 2) and was told I was wrong, as I needed to select option 2 & 3. However option 3 returns the results in the following order:
EmpName DateOfLeaving
dcd 2000-08-10 00:00:00.000
abc 1999-10-10 00:00:00.000
bcd 1998-11-11 00:00:00.000
ccd NULL
eed NULL
and the question stated that the solution should be:
EmpName DateOfLeaving
Bcd 11 Nov 1998
Abc 10 Oct 1999
Dcd 10 Aug 2000
Ccd null
Eed null
Therefore I guess thtat the question is worng. At least I should get a point for writing this reply! :P
Regards,
Phil
Post #521589
Derek Dongray
Derek Dongray
Posted Monday, June 23, 2008 3:02 AM
Ten Centuries
Group: General Forum Members
Last Login: Monday, May 13, 2013 2:04 AM
Points: 1,342,
Visits: 1,946
Glad to see I'm not alone in deciding immediately that answer #3 with DateOfLeaving
DESC
wouldn't put the dates in the right order so is definitely wrong, irrespective of where the NULLs come!
Derek
Post #521593
Mighty
Mighty
Posted Monday, June 23, 2008 3:12 AM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 8:33 AM
Points: 2,722,
Visits: 987
Only option 2 gives result as shown in the question, but reading back the question, I get really confused if that even was what was asked.
The question is to have list off all employees with the employees
with DateOfLeaving coming last
Doesn't this mean that employees without DateOfLeaving (the null values), should be first in the result set?!
Guess the only good solution is to give everybody their points :D
Post #521598
luca.pierobon
luca.pierobon
Posted Monday, June 23, 2008 3:24 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, January 08, 2009 1:32 AM
Points: 129,
Visits: 35
The question is to have list off all employees with the employees with DateOfLeaving coming last and all others sorted ascending order of date of leaving
Maybe he wanted to say this?
The question is to have list off all employees with the employees with
out
DateOfLeaving coming last and all others sorted ascending order of date of leaving
Anyway the two answers which they say being correct have different results, so at least one of them is wrong... #3 in my opinion is wrong and I was very surprised of it when I was told that #2 alone was not correct ;)
Post #521603
Anipaul
Anipaul
Posted Monday, June 23, 2008 3:46 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Yesterday @ 1:35 AM
Points: 4,789,
Visits: 1,336
Another controversial question, where you tend to lose points though u know the answer....
Post #521611
« Prev Topic
|
Next Topic »
139 posts, Page 2 of 14
««
1
2
3
4
5
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
