# Re: sql的问题

Posted by David Wong on August 07, 1998 at 15:46:24:

In Reply to: sql的问题 posted by 丸子 on August 06, 1998 at 15:57:20:

第一种方法在一些 System 是不行的，而且印像中这不是 Ansi SQL 的写法，所以我觉得最好不要用。

: 请问
: 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的问题 丸子 15:04:33 8/13/98 (0)