这是MS SQL的写法,不知道这个你能不能用,试下
Select Count(*) from quote_temp
Where stat = 'W' And Not Exists(Select * from quote_special Where quote_num=quote_temp.quote_num And quote_line=quote_temp.quote_line)
Select Count(*) from quote_temp
Where stat = 'W' And Not Exists(Select * from quote_special Where quote_num=quote_temp.quote_num And quote_line=quote_temp.quote_line)
min(cust_grade),min(quote_temp.cust_num),min(name),min(quote_temp.quote_date),min(inputman_name),
COUNT(*) qty //该处要求select一个满足1、2条件的纪录条数;
from quote_temp
inner join quote_special
on quote_temp.quote_num <> quote_special.quote_num
and quote_temp.quote_line <> quote_special.quote_line
and quote_temp.stat = 'W'
GROUP BY quote_num order by input_date DESC
min(cust_grade),min(quote_temp.cust_num),min(name),min(quote_temp.quote_date),min(inputman_name),
COUNT(*) qty //该处要求select一个满足1、2条件的纪录条数;
from quote_temp
inner join quote_special
on quote_temp.quote_num <> quote_special.quote_num
and quote_temp.quote_line <> quote_special.quote_line
and quote_temp.stat = 'W'
GROUP BY quote_temp.quote_num order by input_date DESC
hsj20041004(光芒) ( ) 信誉========================================
SELECT quote_temp.quote_num,min(quote_temp.yy_code),
min(cust_grade),min(quote_temp.cust_num),min(name),min(quote_temp.quote_date),min(inputman_name),
COUNT(*) qty //该处要求select一个满足1、2条件的纪录条数;
from quote_temp
inner join quote_special
on quote_temp.quote_num <> quote_special.quote_num
and quote_temp.quote_line <> quote_special.quote_line
and quote_temp.stat = 'W'
GROUP BY quote_temp.quote_num order by input_date DESC
========================================你的执行结果与我上面写的一样,COUNT(*) qty 的纪录条数是错的。
SELECT
COUNT(*) qty ;
from quote_temp
inner join quote_special
on quote_temp.quote_num <> quote_special.quote_num
and quote_temp.quote_line <> quote_special.quote_line
and quote_temp.stat = 'W'
你直接这样行吗?
SELECT
COUNT(*) qty ;
from quote_temp
inner join quote_special
on quote_temp.quote_num <> quote_special.quote_num
and quote_temp.quote_line <> quote_special.quote_line
and quote_temp.stat = 'W'------------------------------------
这样是不行的。
因为我要的输出结果为:+-----------------------------------------------------------------------------+
|quote_num | qty | yy_code | cust_grade |cust_num| name | quote_date|input_num|
+-----------------------------------------------------------------------------+你上面的SQL语句,是完成不了的。谢谢