求一SQL语句(200)

T

tjh2004

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-03-19

• #1

如下：2005-9-9 DEC 12005-9-10 DEC 22005-9-9 SEC 12005-9-10 SEC 2要求只用一SQL语句显示如下2005-9-9 DEC SEC 12005-9-10 DEC SEC 2帮帮忙!

 

Z

znxia

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-03-19

• #2

Select Data字段, Dec字段, min(最后一个字段)From 表group by Data字段, Dec字段

 

D

de410

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-03-19

• #3

意思好像没有表达清楚~~

 

D

de410

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-03-19

• #4

假设 A B C2005-9-9 DEC 12005-9-10 DEC 22005-9-9 SEC 32005-9-10 SEC 2SELECT B, MIN(C) AS CFROM Table1GROUP BY B

 

Z

znxia

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-03-19

• #5

他不继续，我就只能猜了。下面SQL是一种思路，或许对你有用Select A, B, (Case when b='DEC' Then C1 Else C2 End) CFrom (Select A, B, Max(C) C1, Min(C) C2 From Table1 )X

 

T

tjh2004

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-03-20

• #6

不好意思啊各位!这几天上不了网我改了一下题目!写出了，是道面试题!

 

T

tjh2004

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-03-20

• #7

其实是个交叉表，不过又包含分组!

 

I

inspur430

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-04-20

• #8

飘过。看错。

 

P

power255

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-04-21

• #9

记号,等有时间再想

 

Y

YYGGQQ

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-04-21

• #10

可以用动态的交叉表：http://www.itstudy.net/html/200904/6/20090406124311.htm 参考

 

E

eloveme

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-04-21

• #11

--建立测试环境create table tmp(A varchar(20),B char(3),C int)insert Into tmp(A,B,C)select '2005-9-9','DEC',1union select '2005-9-10', 'DEC',2Union select '2005-9-9', 'SEC',1union select '2005-9-10', 'SEC',2--根据要求过滤数据select a.a,a.c,a.DEC,b.SECfrom(Select A,C,Case B when 'DEC' then 'DEC' end DECfrom tmp) a inner join (Select A,C,Case B when 'SEC' then 'SEC' end SEC from tmp ) b On a.A = b.A and a.c =b.Cwhere a.DEC is not null and b.SEC is not nullorder by a.c

 

T

tjh2004

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-04-21

• #12

各位是一条sql语句!是道面试题相信对大家有帮助

 

T

tjh2004

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-04-21

• #13

不能使用硬代码

 

D

deardai

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2009-04-22

• #14

select column1,max(case when column2='DEC' then 'DEC' end) column11,max(case when column2='SEC' then 'SEC' end) column12,column3 from tablenamegroup by column1,column3