Welcome -
Guest!
Login
/
Register Now
|
Search:
Home
Articles
Forum
Interview FAQ
Activities
News
Videos
Poll
Links
People
Groups
Oracle Articles
Submit Article
Home
»
Articles
»
Oracle
»
Operators
RSS Feeds
USING UNION WITH ORDER BY
Posted By:
Brooke Hughes
Category:
Oracle
Views:
2247
This article explains about using USING UNION WITH ORDER BY with example.
Customer - orders - salespeople database
USING UNION WITH ORDER BY
SELECT snum AS CODE,sname AS NAME FROM Salespeople WHERE city='ahmd'
UNION
SELECT cnum,cname FROM Customers WHERE city='ahmd'
ORDER BY 2;
Share:
Previous Post:
UNION QUERY
Next Post:
INTERSECTION OPERATOR
Didn't find what you were looking for? Find more on
USING UNION WITH ORDER BY
Or get
search suggestion and latest updates
.
Brooke Hughes
author of USING UNION WITH ORDER BY is from London,
United Kingdom
.
View All Articles
Related Articles and Code:
Display item details in descending order of item price using order by clause in select query
UNION
UNION QUERY
Structures And Unions
Example of union
Program to illustrate the relationship b/w union and structure
Prolog program to merge two ordered list generating an ordered list
Program to sort a list in alphabatic order using pointers
Program that prints first 20 integers in reverse order (using while loop )
Write a shell script to sort the given numbers in descending order using Bubble sort
Program to sort a list in ascending order using binary search
Display customers detail in a ascending order of customer name using order by clause in a select query
Program to read numbers from two files using fscanf function and write it in another file using fprintf function in ascending order
Prolog program of predicate ordered (List) which is true if List is an ordered list of numbers
Program to print a Single Ended Linked List in Original & Reverse order and sort it in Ascending & Decending Order
Sorting Rows with ORDER BY
Program to print Lower Case Letters from a to z in reverse order
Program to sort numbers in ascending order and use integer pointer to store numbers
Program to draw a 3D Piece-Wise Bezier Curve of nth degree with Zeroth Order Continuity
Program to draw a C-Curve of nth order
Other Interesting Articles in Oracle:
CREATE INDEX
Database of Doctor information related to total patient age wise in his hospital
Example to concatenate a string using select query
DROP INDEX
Example to create view
Example to create an index
Example of natural join
Display invoice items of invoice id I010
DEALLOCATE CURSOR
USING EXISTS with CO-RELATED SUB-QUERIES
Write a query to find the last day of the month
INTERSECT Clause
ROLLBACK TRANSACTION
Student Enrollment System Database
Example to create sequence
Example to find employees from state 'Delhi' using select query
CREATE USER
Display highest item price of item table using max() function
COMMIT TRANSACTION
Display student records whose name starts with 'm' using like % operator
Please enter your Comment
Comment should be atleast 30 Characters.
Please put code inside [Code] your code [/Code].
Please login to post comment
No Comment Found, Be the First to post comment!
Oracle
View All
Aggregate Functions
Analytical Functions
Common Statements
Constraints
Cursor
Data Control Language
Data Definition Lang
Data Manipulation Lang
Data Type
Database
Date Time Functions
Functions
Index
Interview FAQ
Joins
Math Functions
Operators
Select Query
Sequence
Stored Procedures
String Functions
Sub Query
System Functions
Transaction Control La...
Trigger
View
Assembly Language
Artificial Intelligence
C Programming
C++ Programming
Visual C++
OOAD
Cobol
Java
SQL Server
Asp.net MVC
Rest and WCF Services
Entity Framework
Knockout.Js
Unix / Linux / Ubuntu
Networking
OOPs Concept
HTML
Dos
SQL
System Analysis & Design
Gadgets
Internet
CSS
Javascript
.Net Framework
Asp.net
C#
VB.Net
Python
Perl
Software Engineering
RDBMS Terms
AJAX Framework
Design Pattern
UML
WPF
WCF
SEO
PowerShell
Visual Studio
WWF
BizTalk Server
Azure
General
Testing
Online Certifications
PHP
My SQL
LinQ
Project Management
Silverlight
XML
MS Office
Windows OS
DHTML
Sharepoint