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 + -
显示快捷键?