Click here to Skip to main content
15,921,577 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: VB6 to VB.NET Marshal Structure Pin
Dave Kreskowiak14-Jul-05 6:44
mveDave Kreskowiak14-Jul-05 6:44 
GeneralRe: VB6 to VB.NET Marshal Structure Pin
meyerengineering14-Jul-05 8:06
meyerengineering14-Jul-05 8:06 
GeneralRe: VB6 to VB.NET Marshal Structure Pin
meyerengineering15-Jul-05 4:16
meyerengineering15-Jul-05 4:16 
GeneralRe: VB6 to VB.NET Marshal Structure Pin
progload15-Jul-05 5:25
progload15-Jul-05 5:25 
Generalopen email Pin
Ali el14-Jul-05 4:52
Ali el14-Jul-05 4:52 
GeneralRe: open email Pin
Dave Kreskowiak14-Jul-05 5:48
mveDave Kreskowiak14-Jul-05 5:48 
GeneralRe: open email Pin
Ali el15-Jul-05 6:22
Ali el15-Jul-05 6:22 
GeneralRe: open email Pin
Dave Kreskowiak15-Jul-05 11:45
mveDave Kreskowiak15-Jul-05 11:45 
GeneralRe: open email Pin
Ali el17-Jul-05 5:03
Ali el17-Jul-05 5:03 
GeneralProblem in Data Reports in VB 6.0 Pin
Birdy14-Jul-05 3:48
Birdy14-Jul-05 3:48 
GeneralRe: Problem in Data Reports in VB 6.0 Pin
rwestgraham14-Jul-05 11:23
rwestgraham14-Jul-05 11:23 
GeneralRe: Problem in Data Reports in VB 6.0 Pin
Birdy15-Jul-05 2:08
Birdy15-Jul-05 2:08 
Generalnahelp me in this printing problem-- nidhi s Pin
pnavkumar@yahoo.co.in14-Jul-05 1:16
susspnavkumar@yahoo.co.in14-Jul-05 1:16 
GeneralRe: nahelp me in this printing problem-- nidhi s Pin
Dave Kreskowiak14-Jul-05 3:31
mveDave Kreskowiak14-Jul-05 3:31 
GeneralRe: nahelp me in this printing problem-- nidhi s Pin
Member 211512814-Jul-05 3:53
Member 211512814-Jul-05 3:53 
GeneralRe: nahelp me in this printing problem-- nidhi s Pin
Dave Kreskowiak14-Jul-05 4:24
mveDave Kreskowiak14-Jul-05 4:24 
GeneralChange SQL Server startup account to SA Pin
Toms Edison14-Jul-05 0:46
Toms Edison14-Jul-05 0:46 
GeneralRe: Change SQL Server startup account to SA Pin
Dave Kreskowiak14-Jul-05 1:16
mveDave Kreskowiak14-Jul-05 1:16 
GeneralSelecting dropdown value automatically Pin
macca2414-Jul-05 0:44
macca2414-Jul-05 0:44 
GeneralRe: Selecting dropdown value automatically Pin
Gavin Jeffrey14-Jul-05 0:50
Gavin Jeffrey14-Jul-05 0:50 
GeneralRe: Selecting dropdown value automatically Pin
Gavin Jeffrey14-Jul-05 0:53
Gavin Jeffrey14-Jul-05 0:53 
GeneralRe: Selecting dropdown value automatically Pin
macca2414-Jul-05 0:56
macca2414-Jul-05 0:56 
GeneralRe: Selecting dropdown value automatically Pin
Gavin Jeffrey14-Jul-05 1:42
Gavin Jeffrey14-Jul-05 1:42 
General<help me>Access Pin
vtalau13-Jul-05 23:44
vtalau13-Jul-05 23:44 
GeneralRe: <help me>Access Pin
SBendBuckeye14-Jul-05 13:01
SBendBuckeye14-Jul-05 13:01 
vtalau wrote:
select .........
from nhanvien
where company is null
union
select .........
from nhanvien
where company is not null


Try This
<br />
select 1, .........<br />
from nhanvien<br />
where company is null<br />
union<br />
select 0, .........<br />
from nhanvien<br />
where company is not null<br />
order by 1<br />

What I did was add a new column in front of your currently selected data and then sorted by column number 1. That should put all of your null items last.


Have a great day!

j2associates_NO_SPAM_@yahoo.com

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.