4472.html

来自「VB技巧问答10000例 VB技巧问答10000例」· HTML 代码 · 共 27 行

HTML
27
字号
<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 <a href="mailto:dbms@bigfoot.com">David Wong</a> on August 07, 1998 at 15:46:24:<p>
In Reply to: <a href="4430.html">sql的问题</a> posted by 丸子 on August 06, 1998 at 15:57:20:<p>
第一种方法在一些 System 是不行的,而且印像中这不是 Ansi SQL 的写法,所以我觉得最好不要用。<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: 4472-->
<!--top: 4694--><li><a href="4694.html">Re: sql的问题</a> <b>丸子</b> <i>15:04:33 8/13/98</i>
(<!--responses: 4694-->0)
<ul><!--insert: 4694-->
</ul><!--end: 4694-->
</ul><!--end: 4472-->
<br><hr size=7 width=75%><p>

</body></html>

⌨️ 快捷键说明

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