SQL Query [message #629520] |
Wed, 10 December 2014 06:49 |
Xandot
Messages: 235 Registered: January 2014 Location: India
|
Senior Member |
|
|
Hello,
I have one table like :-
with t as (
select 'A' G, 'A1' F,'A1A' C from dual union
select 'A' G, 'A1' F,'A1B' C from dual union
select 'A' G, 'A2' F,'A2A' C from dual union
select 'A' G, 'A2' F,'A2B' C from dual union
select 'X' G, 'X1' F,'X1A' C from dual union
select 'X' G, 'X1' F,'X1B' C from dual union
select 'X' G, 'X2' F,'X2A' C from dual union
select 'X' G, 'X2' F,'X2B' C from dual)
select * from t
I want Output like:-
G F C
-------------------
A A1 A1A
A1B
A2 A2A
A2B
X X1 X1A
X1B
X2 X2A
X2B
Thanks,
Xandot
|
|
|
Re: SQL Query [message #629523 is a reply to message #629520] |
Wed, 10 December 2014 07:14 |
John Watson
Messages: 8931 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
You need to add an ORDER BY clause, otherwise that should be fine.
If you want to suppress repeated values in the output, you will need to read up on how your client tool can do that (if it can). You didn't say what client tool you are using.
|
|
|
Re: SQL Query [message #629527 is a reply to message #629520] |
Wed, 10 December 2014 08:07 |
|
LKBrwn_DBA
Messages: 487 Registered: July 2003 Location: WPB, FL
|
Senior Member |
|
|
In sql*plus try this:
SQL> break on G on F
SQL> with t as (
2 select 'A' G, 'A1' F,'A1A' C from dual union
3 select 'A' G, 'A1' F,'A1B' C from dual union
4 select 'A' G, 'A2' F,'A2A' C from dual union
5 select 'A' G, 'A2' F,'A2B' C from dual union
6 select 'X' G, 'X1' F,'X1A' C from dual union
7 select 'X' G, 'X1' F,'X1B' C from dual union
8 select 'X' G, 'X2' F,'X2A' C from dual union
9 select 'X' G, 'X2' F,'X2B' C from dual)
10 select * from t order by G,F,C
11 /
G F C
--- ------ ---------
A A1 A1A
A1B
A2 A2A
A2B
X X1 X1A
X1B
X2 X2A
X2B
8 rows selected.
[Updated on: Wed, 10 December 2014 08:38] by Moderator Report message to a moderator
|
|
|
|