# Re: sql的问题

Posted by 丸子 on August 13, 1998 at 15:04:33:

In Reply to: Re: sql的问题 posted by David Wong on August 07, 1998 at 15:46:24:

: 第一种方法在一些 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: