Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to concatenate two sql statements?

705869Jun 21 2009 — edited Jun 22 2009
Hello,

How can I combine the following two sql statements so that the one row result from the first statement appears before the rows from my second sql statement. The reason I need this is to order the rows appropriately.

select username, id
from abusers
where id = 0

select username, id
from abusers
where id != 0
order by username

Thanks,
j
This post has been answered by Nicolas Gasparotto on Jun 21 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 20 2009
Added on Jun 21 2009
12 comments
2,507 views