Hi SET,
I got the answer from below URL.
How To Display Null Values At the End For More Than One Columns Specified in
Order By Clause?
| |
| | | | | | | |
| How To Display Null Values At the End For More Than O...I am using Firebird
database. I have one issue in Order By clause. I have SQL which gives multile
records for multiple employees, i.e. one employee has multiple rec... |
| |
| View on stackoverflow.com | Preview by Yahoo |
| |
| |
Thank You for putting your efforts and sorry for my incomplete information.
With Best Regards.
Vishal
On Friday, 13 March 2015 12:45 PM, "Svein Erling Tysvær
[email protected] [firebird-support]"
<[email protected]> wrote:
Thanks for the SQL code, Vishal, you forgot to include b) (Parts of) the
result you getc) The result you want Both of these are necessary to find out
how to write the required SQL. Set #yiv3608841307 #yiv3608841307 --
#yiv3608841307ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}#yiv3608841307 #yiv3608841307ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv3608841307 #yiv3608841307ygrp-mkp #yiv3608841307hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3608841307 #yiv3608841307ygrp-mkp #yiv3608841307ads
{margin-bottom:10px;}#yiv3608841307 #yiv3608841307ygrp-mkp .yiv3608841307ad
{padding:0 0;}#yiv3608841307 #yiv3608841307ygrp-mkp .yiv3608841307ad p
{margin:0;}#yiv3608841307 #yiv3608841307ygrp-mkp .yiv3608841307ad a
{color:#0000ff;text-decoration:none;}#yiv3608841307 #yiv3608841307ygrp-sponsor
#yiv3608841307ygrp-lc {font-family:Arial;}#yiv3608841307
#yiv3608841307ygrp-sponsor #yiv3608841307ygrp-lc #yiv3608841307hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3608841307
#yiv3608841307ygrp-sponsor #yiv3608841307ygrp-lc .yiv3608841307ad
{margin-bottom:10px;padding:0 0;}#yiv3608841307 #yiv3608841307actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3608841307
#yiv3608841307activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3608841307
#yiv3608841307activity span {font-weight:700;}#yiv3608841307
#yiv3608841307activity span:first-child
{text-transform:uppercase;}#yiv3608841307 #yiv3608841307activity span a
{color:#5085b6;text-decoration:none;}#yiv3608841307 #yiv3608841307activity span
span {color:#ff7900;}#yiv3608841307 #yiv3608841307activity span
.yiv3608841307underline {text-decoration:underline;}#yiv3608841307
.yiv3608841307attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3608841307 .yiv3608841307attach div a
{text-decoration:none;}#yiv3608841307 .yiv3608841307attach img
{border:none;padding-right:5px;}#yiv3608841307 .yiv3608841307attach label
{display:block;margin-bottom:5px;}#yiv3608841307 .yiv3608841307attach label a
{text-decoration:none;}#yiv3608841307 blockquote {margin:0 0 0
4px;}#yiv3608841307 .yiv3608841307bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3608841307
.yiv3608841307bold a {text-decoration:none;}#yiv3608841307 dd.yiv3608841307last
p a {font-family:Verdana;font-weight:700;}#yiv3608841307 dd.yiv3608841307last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3608841307
dd.yiv3608841307last p span.yiv3608841307yshortcuts
{margin-right:0;}#yiv3608841307 div.yiv3608841307attach-table div div a
{text-decoration:none;}#yiv3608841307 div.yiv3608841307attach-table
{width:400px;}#yiv3608841307 div.yiv3608841307file-title a, #yiv3608841307
div.yiv3608841307file-title a:active, #yiv3608841307
div.yiv3608841307file-title a:hover, #yiv3608841307 div.yiv3608841307file-title
a:visited {text-decoration:none;}#yiv3608841307 div.yiv3608841307photo-title a,
#yiv3608841307 div.yiv3608841307photo-title a:active, #yiv3608841307
div.yiv3608841307photo-title a:hover, #yiv3608841307
div.yiv3608841307photo-title a:visited {text-decoration:none;}#yiv3608841307
div#yiv3608841307ygrp-mlmsg #yiv3608841307ygrp-msg p a
span.yiv3608841307yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3608841307
.yiv3608841307green {color:#628c2a;}#yiv3608841307 .yiv3608841307MsoNormal
{margin:0 0 0 0;}#yiv3608841307 o {font-size:0;}#yiv3608841307
#yiv3608841307photos div {float:left;width:72px;}#yiv3608841307
#yiv3608841307photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv3608841307
#yiv3608841307photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3608841307
#yiv3608841307reco-category {font-size:77%;}#yiv3608841307
#yiv3608841307reco-desc {font-size:77%;}#yiv3608841307 .yiv3608841307replbq
{margin:4px;}#yiv3608841307 #yiv3608841307ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3608841307 #yiv3608841307ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3608841307
#yiv3608841307ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3608841307
#yiv3608841307ygrp-mlmsg select, #yiv3608841307 input, #yiv3608841307 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3608841307
#yiv3608841307ygrp-mlmsg pre, #yiv3608841307 code {font:115%
monospace;}#yiv3608841307 #yiv3608841307ygrp-mlmsg *
{line-height:1.22em;}#yiv3608841307 #yiv3608841307ygrp-mlmsg #yiv3608841307logo
{padding-bottom:10px;}#yiv3608841307 #yiv3608841307ygrp-msg p a
{font-family:Verdana;}#yiv3608841307 #yiv3608841307ygrp-msg
p#yiv3608841307attach-count span {color:#1E66AE;font-weight:700;}#yiv3608841307
#yiv3608841307ygrp-reco #yiv3608841307reco-head
{color:#ff7900;font-weight:700;}#yiv3608841307 #yiv3608841307ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3608841307 #yiv3608841307ygrp-sponsor
#yiv3608841307ov li a {font-size:130%;text-decoration:none;}#yiv3608841307
#yiv3608841307ygrp-sponsor #yiv3608841307ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3608841307
#yiv3608841307ygrp-sponsor #yiv3608841307ov ul {margin:0;padding:0 0 0
8px;}#yiv3608841307 #yiv3608841307ygrp-text
{font-family:Georgia;}#yiv3608841307 #yiv3608841307ygrp-text p {margin:0 0 1em
0;}#yiv3608841307 #yiv3608841307ygrp-text tt {font-size:120%;}#yiv3608841307
#yiv3608841307ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3608841307
