Re: [SQL ] 查詢前十大的資料

看板Database (資料庫)作者qrtt1 (愚者)時間18年前 (2006/10/19 20:01)推噓0(0推 0噓 0→)

留言0則, 0人參與討論串2/5 (看更多)

※ 引述《yoco315 (眠月)》之銘言： : 就是先依照價錢 group 以後 : 列出前十高的價錢，找出當中最便宜的那個 : 之後把地價大於等於這個價錢的地名都印出來 : 可是 LIMIT 不能用，我就覺得很困惑，無能為力 : 而且老師要求的是要用標準語法， : 就算 Oracle 能用 LIMIT 我似乎也不能用上他 : 請教前輩們，感謝。 http://owen.sj.ca.us/~rk/howto/sql92.html 此網頁的sql92中有LIMIT耶不過.... specifiction http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt <% Note: The list of <reserved word>s is considerably longer than the analogous list of <key word>s in ISO/IEC 9075:1989. To assist users of this International Standard avoid such words in a possible future revision, the following list of potential <reserved word>s is provided. Readers must understand that there is no guarantee that all of these words will, in fact, become <reserved word>s in any future revision; furthermore, it is almost certain that additional words will be added to this list as any possible future revision emerges. The words are: AFTER, ALIAS, ASYNC, BEFORE, BOOLEAN, BREADTH, COMPLETION, CALL, CYCLE, DATA, DEPTH, DICTIONARY, EACH, ELSEIF, EQUALS, GENERAL, IF, IGNORE, LEAVE, LESS, LIMIT, LOOP, MODIFY, NEW, NONE, OBJECT, OFF, OID, OLD, OPERATION, OPERATORS, OTHERS, PARAMETERS, PENDANT, PREORDER, PRIVATE, PROTECTED, RECURSIVE, REF, REFERENCING, REPLACE, RESIGNAL, RETURN, RETURNS, ROLE, ROUTINE, ROW, SAVEPOINT, SEARCH, SENSITIVE, SEQUENCE, SIGNAL, SIMILAR, SQLEXCEPTION, SQLWARNING, STRUCTURE, TEST, THERE, TRIGGER, TYPE, UNDER, VARIABLE, VIRTUAL, VISIBLE, WAIT, WHILE, and WITHOUT. %> 只是建議要加入的功能，殘念!!! 至於有沒有通用的解法並不清楚@@ 但有人分享了各別的解法 http://dotnet.org.za/thea/archive/2005/02/22/14715.aspx -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 163.26.34.20 ※ 編輯: qrtt1 來自: 163.26.34.20 (10/19 20:15)