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 #4
-
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
-
25th October 2012 21:59 #7




Reply With Quote

Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in