Home Forums Article Discussions Article Discussions by Author Discuss content posted by Arup Chakraborty Predict output RE: Predict output
Adam Machanic
SSCoach
Points: 15370
More actions
October 30, 2008 at 12:49 pm
#892046
As others have mentioned, a sort is not the only option, and the NULL may or may not come first... No one actually showed this yet, though, so here you go:
SELECT 1 UNION SELECT NULL UNION SELECT '1'
OPTION (HASH UNION)
--Adam Machanicwhoisactive