Help on Oracle Query - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Help on Oracle Query

Help on Oracle Query# Database - 数据库

b*y2009-12-15 08:12

1 楼

I have a record set like below:
CloseDate Category Price
2009-12-09 C1 100.21
2009-12-09 C2 98.41
2009-12-09 C3 96.41
2009-12-08 C1 100.13
2009-12-08 C2 98.33
2009-12-08 C3 96.33
2009-12-07 C1 100.2
2009-12-07 C2 98.25
2009-12-07 C3 96.25
2007-10-05 C4 97.4
2007-10-04 C4 97.3
2007-10-03 C4 97.3
2007-10-04 C5 98.5
2007-10-03 C5 98.4
I am trying to write a query to get columns includin

c*t2009-12-15 08:12

2 楼

home work?

【在 b******y 的大作中提到】

: I have a record set like below:
: CloseDate Category Price
: 2009-12-09 C1 100.21
: 2009-12-09 C2 98.41
: 2009-12-09 C3 96.41
: 2009-12-08 C1 100.13
: 2009-12-08 C2 98.33
: 2009-12-08 C3 96.33
: 2009-12-07 C1 100.2
: 2009-12-07 C2 98.25

b*y2009-12-15 08:12

3 楼

This is for work.

【在 c**t 的大作中提到】

: home work?

c*t2009-12-15 08:12

4 楼

a classical pivot query

【在 b******y 的大作中提到】

: This is for work.

B*g2009-12-15 08:12

5 楼

when you ask oracle questine, let us know your oracle version.

【在 b******y 的大作中提到】

b*y2009-12-15 08:12

6 楼

Oracle 10g

【在 B*****g 的大作中提到】

: when you ask oracle questine, let us know your oracle version.

B*g2009-12-15 08:12

7 楼

SELECT *
FROM (SELECT closedate,
MAX(DECODE(category, 'C1', price, 0)) c1,
MAX(DECODE(category, 'C2', price, 0)) c2,
MAX(DECODE(category, 'C3', price, 0)) c3,
MAX(DECODE(category, 'C4', price, 0)) c4,
MAX(DECODE(category, 'C5', price, 0)) c5
FROM tbl
GROUP BY closedate)

【在 b******y 的大作中提到】

: Oracle 10g