informix日期函数_informix_informix rownum(2)

FROM customer c RIGHT OUTER JOIN orders o

ON (c.customer_num = o.customer_num);

WHERE 字查询 的条件语句

ALL

ANY

IN

EXISTS

SELECT order_num, stock_num, manu_code, total_price

FROM items

WHERE total_price < ALL

(SELECT total_price FROM items

WHERE order_num = 1023)

SELECT DISTINCT order_num

FROM items

WHERE total_price > ANY

(SELECT total_price

FROM items

WHERE order_num = 1005)

SELECT order_num FROM items

WHERE stock_num = 9

AND quantity =

(SELECT MAX (quantity)

FROM items

WHERE stock_num = 9)

SELECT UNIQUE manu_name, lead_time

FROM manufact

WHERE EXISTS

(SELECT * FROM stock

WHERE description MATCHES ’*shoe*’

AND manufact.manu_code = stock.manu_code)

SELECT UNIQUE manu_name, lead_time

FROM stock, manufact

WHERE manufact.manu_code IN

(SELECT manu_code FROM stock

WHERE description MATCHES ’*shoe*’)

AND stock.manu_code = manufact.manu_code

SELECT customer_num, company FROM customer

WHERE customer_num NOT IN

(SELECT customer_num FROM orders

WHERE customer.customer_num = orders.customer_num)

SELECT customer_num, company FROM customer

WHERE NOT EXISTS

(SELECT * FROM orders

WHERE customer.customer_num = orders.customer_num)

CREATE TABLE accounts (

acc_num SERIAL primary key,

acc_type INT,

acc_descr CHAR(20));

CREATE TABLE sub_accounts (

sub_acc INTEGER primary key,

ref_num INTEGER REFERENCES accounts (acc_num)

ON DELETE CASCADE,

sub_descr CHAR(20));

删除将回导致级联删除

DELETE FROM accounts WHERE acc_num = 2

CREATE INDEX ix_cust ON orders (customer_num);

ALTER INDEX ix_cust TO CLUSTER;//以物理方式排序

本文来自电脑杂谈，转载请注明本文网址：
http://www.pc-fly.com/a/jisuanjixue/article-31716-2.html