Home » RDBMS Server » Server Administration » Re: Matrix Query
Re: Matrix Query [message #374707] Mon, 25 June 2001 19:08
J.S HAN
Messages: 12
Registered: November 2000
Junior Member
Hi

how about this.

select
name,
max(decode(id,10,id_val)) COLUMN1,
max(decode(id,20,id_val)) COLUMN2
from table1
group by name

Report message to a moderator

Previous Topic: SQL Loader: re-enabling constraints
Next Topic: Limit records returned by a select
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 18:52:44 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.