OraFAQ Forum: SQL & PL/SQL » SQL query problem

Home » SQL & PL/SQL » SQL & PL/SQL » SQL query problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL query problem [message #2925]

Thu, 22 August 2002 07:09

Prasad Joshi
Messages: 3
Registered: August 2002

Junior Member

Hello Oracle Champs

I want to build one query.I have one table 'end_details' and columns are aend,bend and descr .
values are like this.

aend bend descr
-------------------
11 22 Test1
33 44 Test2
55 66 Test3
22 11 Test4
65 45 Test5
88 99 Test6
45 65 Test7

I want output in the following order as follows.

aend bend descr
-------------------
11 22 Test1
22 11 Test4
33 44 Test2
55 66 Test3
65 45 Test5
45 65 Test6
88 99 Test6

Is this by anyway possible by performing such grouping using SQL only ?

Prasad

Report message to a moderator

Re: SQL query problem [message #2967 is a reply to message #2925]

Mon, 26 August 2002 21:01

Gilbey
Messages: 87
Registered: March 2002

Member

try this..

select aend, bend, descr from end_details
order by aend;

Hope this should work.

Cheers
Gilbey

Report message to a moderator

Previous Topic:	Multiple Data Entry Thru PL/Sql !
Next Topic:	need a procedure for ftp

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 00:46:25 CDT 2024