查询中怎样写不等于???

[cuihao]

...where id 不等于 no_id...
这样改怎样写,数据库是sql server

[icevi]

where id <> no_id

[pengdali]

<> 不等于
!< 不小于
!> 不大与

[世A界]

加号的用法
SELECT @startdate + 1.25 AS 'Start Date',
@startdate + @adddays AS 'Add Date'
减法的用法
SELECT title,
(
(price * ytd_sales) * CAST( ( (100 - royalty) / 100.0 )
AS MONEY)
) AS IncomeAfterRoyalty
FROM titles
乘法的用法
SELECT title_id, price * 1.15 AS NewPrice
FROM titles
WHERE type = 'mod_cook'
ORDER BY title_id ASC

例如，如果假定每个出版商只位于一个城市，而您要找到居住在 Algodata Infosystems 所在城市中的作者的姓名，就可以通过由简单的等号 (=) 比较运算符引入的子查询编写一条语句。

USE pubs
SELECT au_lname, au_fname
FROM authors
WHERE city =
(SELECT city
FROM publishers
WHERE pub_name = 'Algodata Infosystems')

下面是结果集：

au_lname au_fname
-------- --------
Carson Cheryl
Bennet Abraham

(2 row(s) affected)

但是，如果 Algodata Infosystems 位于多个城市中，则会产生一条错误信息。可以使用 IN 表达式（= ANY 也可以）代替 = 比较运算符。

由未修改的比较运算符引入的子查询经常包括聚合函数，因为这些子查询要返回单个值。例如，下面的语句查找所有价格高于当前最低价的书籍的名称。

USE pubs
SELECT DISTINCT title
FROM titles
WHERE price >
(SELECT MIN(price)
FROM titles)

下面是结果集：

title
----------------------------------------------------------
But Is It User Friendly?
Computer Phobic and Non-Phobic Individuals: Behavior Variations
Cooking with Computers: Surreptitious Balance Sheets
Emotional Security: A New Algorithm
Fifty Years in Buckingham Palace Kitchens
Is Anger the Enemy?
Life Without Fear
Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean
Prolonged Data Deprivation: Four Case Studies
Secrets of Silicon Valley
Silicon Valley Gastronomic Treats
Straight Talk About Computers
Sushi, Anyone?
The Busy Executive's Database Guide

(14 row(s) affected)

因为由未修改的比较运算符引入的子查询必须返回单个值，所以除非知道 GROUP BY 或 HAVING 子句本身会返回单个值，否则不能包括 GROUP BY 或 HAVING 子句。例如，下面的查询查找价格高于类型为"trad_cook"的书籍的最低价格的书。

USE pubs
SELECT DISTINCT title
FROM titles
WHERE price >
(SELECT MIN(price)
FROM titles
GROUP BY type
HAVING type = 'trad_cook')

下面是结果集：

title
------------------------------------------------------------------------
But Is It User Friendly?
Computer Phobic AND Non-Phobic Individuals: Behavior Variations
Onions, Leeks, and Garlic: Cooking Secrets of the Mediterranean
Prolonged Data Deprivation: Four Case Studies
Secrets of Silicon Valley
Silicon Valley Gastronomic Treats
Straight Talk About Computers
Sushi, Anyone?
The Busy Executive's Database Guide

(9 row(s) affected)