All pastes #967163 Raw Edit

Unnamed

public text v1 · immutable
·published 2008-04-02 06:47 UTC
rendered paste body
/*
select *
FROM product;

select ordid
FROM ord;

select custid,name,address,city
FROM customer

select name
FROM customer
where creditlimit>6000;

select ordid,orderdate,custid,total
FROM ord
where total>=5000;
*/
select total
from ord
where total<5000
group by