SELECT * FROM sometable ORDER BY col1 ASC NULLS FIRST
BibleGateway.com Verse Of The Day
“ Now Jesus was going up to Jerusalem. On the way, he took the Twelve aside and said to them, “We are going up to Jerusalem, and the Son of Man will be delivered over to the chief priests and the teachers of the law. They will condemn him to death and will hand him over to the Gentiles to be mocked and flogged and crucified. On the third day he will be raised to life!”” (Matthew 20: 17-19) 
(Read by Max McLean. Provided by The Listener's Audio Bible.)
Powered by BibleGateway.com
(Read by Max McLean. Provided by The Listener's Audio Bible.)Powered by BibleGateway.com
Wednesday, August 18, 2010
Oracle Sorting of NULL Values
Speaking of Oracle crap, a few weeks ago while working on this project, the question came up of how Oracle sorts NULL values in an ORDER BY clause. I looked it up, and learned something new. Hooray for learning new stuff. I didn't realize you can specify how to sort NULL's in your ORDER BY clause. You add "NULLS FIRST" or "NULLS LAST" like this....
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment