Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Nulls last (Read 2016 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Nulls last
16.02.11 at 10:06:39
 
Nulls last
 
´Nulls last´ can be used in Oracle SQL to prevent null values to be listed at the top of an ordered query.
 
Consider:
select col1 from table order by col1 desc
 
Rows with a null value in col1 will be sorted at the top. To move these to the bottom of the recordset you can use the 'nulls last' directive:
select col1 from table order by col1 desc nulls last
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1