# sql的问题

Posted by 丸子 on August 06, 1998 at 15:57:20:

请问
sql = "Select Title, Salary " _
& "from Employees as T1 where Salary >= " _
& "(select Avg(Salary) from Employees " _
& "where T1.Title=Employees.Title) order by Title"

与

sql = "Select Title, Salary " _
& "from Employees as T1 where Salary >= " _
& "(select Avg(Salary) from Employees) order by Title "

有何不同呢?

Follow Ups:

- Re: sql的问题 David Wong 15:46:24 8/07/98 (1)
  - Re: sql的问题 丸子 15:04:33 8/13/98 (0)