C coolfun Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-18 #1 select a.ssh,count(b.cch) as c from item as a ,lend_hist as b where a.cch=b.cch group by a.ssh order by c desc
select a.ssh,count(b.cch) as c from item as a ,lend_hist as b where a.cch=b.cch group by a.ssh order by c desc
M Mark_zheng Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-18 #2 select a.ssh ,count(b.cch) c from item a ,lend_hist b where a.cch=b.cch group by a.shh order by c 呵呵!!好象是这样写!
select a.ssh ,count(b.cch) c from item a ,lend_hist b where a.cch=b.cch group by a.shh order by c 呵呵!!好象是这样写!
C coolfun Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-18 #3 这条语句在MSSQL里能正确执行,但是在ORCAL里面执行时,出现"SQL 语句没有结束"的提示. 请问我应该怎么改这条程序.
M Mark_zheng Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-18 #4 用 ;号啊!!!ORACLE里面一句话的结尾是 ;
C coolfun Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-18 #5 不要用分号的,Mark_zheng说对了一点,还有我那句话的ORDERBY不应该连在一起.
C coolfun Unregistered / Unconfirmed GUEST, unregistred user! 2002-12-18 #6 你运气真好,送你100了.我可是又花了比较长的时间查书的.