Results 1 to 8 of 8

Thread: SQL

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered 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 = ' ';
    :

    Code:
    OPERATOR_NAME	  NOMERFAKT	WSICHKO
     	  465	                30.84
     	  467	                140.4
     	  2143                21.12
    , , , WSICHKO e - - .. max WSICHKO.

    !

  2. #2
    The Unknown rager's Avatar
    Join Date: Jul:2004
    Location: Edge Of Darkness
    Posts: 30,360
    , :
    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

  3. #3
    Registered User
    Join Date: Jul:2001
    Location:
    Posts: 329
    rager , select group by .
    :
    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;
    Microsoft SQL Server. MySQL "top 1" "limit 1" select from.

  4. #4
    Registered User
    Join Date: Oct:2012
    Location:
    Posts: 3
    Quote Originally Posted by Dorkas View Post
    rager , select group by .
    :
    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;
    Microsoft SQL Server. MySQL "top 1" "limit 1" select from.
    oracle, 3- .

  5. #5
    Registered 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
    .

  6. #6
    Registered User
    Join Date: Oct:2012
    Location:
    Posts: 3

    !

    Quote Originally Posted by vp_petrov View Post
    oracle, 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=' '

  7. #7
    XaMaB's Avatar
    Join Date: Nov:2001
    Location:
    Posts: 20,387
    Quote Originally Posted by vp_petrov View Post
    ,

    :

    Code:
    ...
    , ' ' MAX(D2.WSICHKO)?

    top 1/limit 1
    Code:
    SELECT *
      FROM (SELECT * FROM table ORDER BY column desc)
     WHERE ROWNUM = 1;
    : XaMaB; . 0.42

    In God we Trust (all others must submit a X.509 certificate). , ()

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |