4694.html

来自「以电子书的形式收集了VB一些常见问题解决方法,可以很方便的查找自己需要解决的问题」· HTML 代码 · 共 23 行

HTML
23
字号
<html>
  <head>
    <title>Re: sql的问题</title>
  </head>
  <body bgcolor="#FFFFFF" vlink="#808080">
    <center>
      <h1>Re: sql的问题</h1>
    </center>
<hr size=7 width=75%>

<hr size=7 width=75%><p>
Posted by 丸子 on August 13, 1998 at 15:04:33:<p>
In Reply to: <a href="4472.html">Re: sql的问题</a> posted by David Wong on August 07, 1998 at 15:46:24:<p>
: 第一种方法在一些 System 是不行的,而且印像中这不是 Ansi SQL 的写法,所以我觉得最好不要用。<p>这个问题我以经解决了<br>谢谢你的帮助<p>: : 请问<br>: :  sql = "Select Title, Salary " _<br>: :      & "from Employees as T1 where Salary >= " _<br>: :      & "(select Avg(Salary) from Employees " _<br>: :      & "where T1.Title=Employees.Title) order by Title"<p>: : 与<p>: :   sql = "Select Title, Salary " _<br>: :      & "from Employees as T1 where Salary >= " _<br>: :      & "(select Avg(Salary) from Employees) order by Title " <p>: : 有何不同呢?<br>: :      <p>
<br>
<br><hr size=7 width=75%><p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 4694-->
</ul><!--end: 4694-->
<br><hr size=7 width=75%><p>

</body></html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?