Results 1 to 8 of 8
Thread: Ïîìîù SQL
Hybrid View
-
25th October 2012 18:56 #1Registered User
Join Date: Oct:2012
Location: Ñîôèÿ
Posts: 3
Ïîìîù SQL
Çäðàâåéòå,
èìàì íóæäà îò ìàëêî ïîìîù ñ SQL.
Èìàì ñëåäíàòà çàÿâêà:
Ðåçóëòàòà å:Code:SELECT OPERATORS.OPERATOR_NAME, DOCUMENT_GL.NOMERFAKT, DOCUMENT_GL.WSICHKO FROM DOCUMENT_GL JOIN OPERATORS ON DOCUMENT_GL.OPER_ID IN ( SELECT OPERATORS.OPER_ID FROM OPERATORS WHERE OPERATORS.OPER_ID = DOCUMENT_GL.OPER_ID ) WHERE OPERATORS.OPERATOR_NAME = 'Èâàí Ãåîðãèåâ';
Êàê äà ïðåïðàâÿ çàÿâêàòà, òàêà, ÷å â ñïèñúêà äà èçëåçå ÑÀÌÎ òîçè ðåä, íà êîéòî ñòîéíîñòòà âúâ êîëîíà WSICHKO e íàé - ãîëÿìà - ò.å. äà ôèëòðèðà ðåçóëòàòèòå ïî max ñòîéíîñò íà êîëîíà WSICHKO.Code:OPERATOR_NAME NOMERFAKT WSICHKO Èâàí Ãåîðãèåâ 465 30.84 Èâàí Ãåîðãèåâ 467 140.4 Èâàí Ãåîðãèåâ 2143 21.12
Áëàãîäàðÿ ïðåäâàðèòåëíî!
-
25th October 2012 20:00 #2
Ïúðâî ïðîáâàé òàêà, ÷å íÿìàì ïîä ðúêà êúäå äà ãî òåñòâàì:
È àêî íå ñòàíå, ùå òðÿáâà äà ñå ïðåïðàâè ïî-ñëîæíî.Code:SELECT OPERATORS.OPERATOR_NAME, DOCUMENT_GL.NOMERFAKT, MAX(DOCUMENT_GL.WSICHKO) FROM DOCUMENT_GL JOIN OPERATORS ON DOCUMENT_GL.OPER_ID IN ( SELECT OPERATORS.OPER_ID FROM OPERATORS WHERE OPERATORS.OPER_ID = DOCUMENT_GL.OPER_ID ) WHERE OPERATORS.OPERATOR_NAME = 'Èâàí Ãåîðãèåâ' GROUP BY DOCUMENT_GL.WSICHKO;Asus CH6H|Ryzen 1800X@4.1GHz|4xBLS8G4D32AESTK@3666MHz 14-19-12-36-58-1T|GB GTX1060 3GB OC|MP510 960GB|SS-1000XP|CM STACKER STC-T01-UW1
Thermochill PA120.2+PA120.3+PA140.3|Yate Loon 5xD12SH-12+3xD14SH-12|Laing DDC 2+Toshiba DIYINHK|EK DDC X-Top v2+EK Reservoir|EK Supreme HF #6
-
25th October 2012 20:25 #3Registered User
Join Date: Jul:2001
Location: Ñîôèÿ
Posts: 329
Ðåøåíèåòî íà rager íÿìà äà ïðîðàáîòè, çàùîòî ñå èçèñêâà ïîëåòàòà âêëþ÷åíè â select äà ïðèñúñòâàò è â group by èëè â àãðåãàòíè ôóíêöèè.
Àç ïðåäëàãàì ñëåäíîòî:
Òîâà å íà äèàëåêò çà Microsoft SQL Server. Çà MySQL âìåñòî "top 1" òðÿáâà äà ñå âúâåäå "limit 1" ñëåä ïîñëåäíîòî ïîëå îò select è ïðåäè from.Code:SELECT top 1 OPERATORS.OPERATOR_NAME, DOCUMENT_GL.NOMERFAKT, DOCUMENT_GL.WSICHKO FROM DOCUMENT_GL JOIN OPERATORS ON DOCUMENT_GL.OPER_ID IN ( SELECT OPERATORS.OPER_ID FROM OPERATORS WHERE OPERATORS.OPER_ID = DOCUMENT_GL.OPER_ID ) WHERE OPERATORS.OPERATOR_NAME = 'Èâàí Ãåîðãèåâ' ORDER BY DOCUMENT_GL.WSICHKO desc;
-
25th October 2012 20:57 #4Registered User
Join Date: Oct:2012
Location: Ñîôèÿ
Posts: 3
-
25th October 2012 21:45 #5Registered User
Join Date: Jul:2001
Location: Ñîôèÿ
Posts: 329
 Oracle íÿìà òàêàâà êîìàíäà, íî íàìåðèõ ïðåïîðúêà êàê ìîæå äà ñå çàîáèêîëè:
Çà ñúæàëåíèå íÿìàì âúçìîæíîñò äà ïðîâåðÿ äàëè ðàáîòè.Code:select * from ( SELECT OPERATORS.OPERATOR_NAME, DOCUMENT_GL.NOMERFAKT, DOCUMENT_GL.WSICHKO FROM DOCUMENT_GL JOIN OPERATORS ON DOCUMENT_GL.OPER_ID IN ( SELECT OPERATORS.OPER_ID FROM OPERATORS WHERE OPERATORS.OPER_ID = DOCUMENT_GL.OPER_ID ) WHERE OPERATORS.OPERATOR_NAME = 'Èâàí Ãåîðãèåâ' ORDER BY DOCUMENT_GL.WSICHKO desc; ) where rownum < 2
-
25th October 2012 21:46 #6Registered User
Join Date: Oct:2012
Location: Ñîôèÿ
Posts: 3
Ðåøåíî!
Áëàãîäàðÿ Âè îùå âåäíúæ çà ñúäåéñòâèåòî, ïîíå ìå íàêëîíèõòå äà ðàáîòÿ â ïðàâèëíàòà ïîñîêà
Ðåøåíèåòî å:
Code:SELECT C1.OPERATOR_NAME, D1.NOMERFAKT, D1.DATAFAKT, D1.WSICHKO FROM DOCUMENT_GL D1, OPERATORS C1 WHERE D1.WSICHKO= (SELECT MAX(D2.WSICHKO) FROM DOCUMENT_GL D2) AND C1.OPERATOR_NAME='Èâàí Ãåîðãèåâ'
-
25th October 2012 21:59 #7Ïîñëåäíà ðåäàêöèÿ: èçâúðøåíà îò XaMaB; íà äíåøíà äàòà. 0.42 ñåêóíäè ñëåä ïóñêàíå íà ïîñòà
In God we Trust (all others must submit a X.509 certificate). Àêî ñïîðèø ñ èäèîò, âåðîÿòíî è òîé ïðàâè ñúùîòî èëè ñè ïîïàäíàë íà ïàðòèåí (íåïúëåí) ÷ëåí




Reply With Quote

Lenovo ThinkPad 15 èëè IdeaPad 15
5th May 2023, 22:16 in Ìîáèëíè êîìïþòðè