請問這句SQL有什麼錯誤，很簡單，但我不知道，謝謝!(30分)

杜

杜風

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-05

• #1

SELECT ID, LEVEL_SORT, adjust_level_enable_date, worker_name, day_salary, overtime_pay, duty_kind, sale_kind, allowance, adjust_man, SK, SK_man
FROM level_query
WHERE adjust_level_enable_date =
( SELECT MAX( adjust_level_enable_date ) tdatetemp
FROM level_query
GROUP BY ID )

 

杜

杜風

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-05

• #2

少了一個AS

 

Y

yzhshi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-05

• #3

SELECT MAX( adjust_level_enable_date ) tdatetemp
FROM level_query
GROUP BY ID 得到的记录可能不是一条。所以在有些数据库上可能存在问题

 

S

svw0506

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-05

• #4

SELECT ID, LEVEL_SORT, adjust_level_enable_date, worker_name, day_salary, overtime_pay, duty_kind, sale_kind, allowance, adjust_man, SK, SK_man
FROM level_query
WHERE adjust_level_enable_date =
( SELECT MAX( adjust_level_enable_date )
FROM level_query
GROUP BY ID )

 

Y

yzhshi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-05

• #5

Oracle出错如下：
single-row subquery returns more than one row

 

杜

杜風

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-05

• #6

是不止一條，但我想實現這外功能，該怎麼寫，請教

 

Y

yzhshi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-05

• #7

Oracle下这样应该可以。SQL Server下这样基本不可以。但是还有别的写法。
SELECT ID, LEVEL_SORT, adjust_level_enable_date, worker_name, day_salary, overtime_pay, duty_kind, sale_kind, allowance, adjust_man, SK, SK_man
FROM level_query a
( SELECT MAX( adjust_level_enable_date ) tdatetemp FROM level_query GROUP BY ID )b
WHERE where a.adjust_level_enable_date =b.tdatetemp

 

D

dopro

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-05

• #8

SELECT ID, LEVEL_SORT, adjust_level_enable_date, worker_name, day_salary, overtime_pay, duty_kind, sale_kind, allowance, adjust_man, SK, SK_man
FROM level_query
WHERE adjust_level_enable_date =
( SELECT MAX( adjust_level_enable_date ) tdatetemp
FROM level_query)
或
SELECT ID, LEVEL_SORT, adjust_level_enable_date, worker_name, day_salary, overtime_pay, duty_kind, sale_kind, allowance, adjust_man, SK, SK_man
FROM level_query
WHERE adjust_level_enable_date =
( SELECT MAX( adjust_level_enable_date ) tdatetemp
FROM level_query)
ORDER BY ID

 

Y

yzhshi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-05

• #9

用In语句来实现很容易，但是速度不好，就是将你的=改成in基本应该可以。

 

S

svw0506

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-05

• #10

所我写的那个 '=' 改为 in, HiHi

 

杜

杜風

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-05

• #11

多人接受答案了。