Results 1 to 7 of 7

Thread: SQL

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User entium's Avatar
    Join Date: May:2003
    Location:
    Posts: 1,426

    SQL


    :
    No
    1 01.07.2022 07.55 1
    2 01.07.2022 08.10 1
    3 02.07.2022 07.56 1
    .
    .
    .
    xx 31.07.2022 07.56 1
    ........................................ ...................................
    1.07.2022 08.00 1
    2.07.2022 08.00 1
    ........................................ ........................................ ..............................
    01.07.2022 16.55 1
    01.07.2022 17.10 1
    02.07.2022 17.00 1
    .
    .
    .
    xx 31.07.2022 16.56 1



    SELECT [vhod7 raboten].[ID], [vhod7 raboten].[No], [vhod7 raboten].[], [vhod7 raboten].[], [vhod7 raboten].[ ()], [vhod7 raboten].[, , ], [vhod7 raboten].[]
    FROM [vhod7 raboten]
    WHERE ((([vhod7 raboten].[])=""))
    ORDER BY [vhod7 raboten].[, , ];



    SELECT [vhod7 raboten].[ID], [vhod7 raboten].[No], [vhod7 raboten].[], [vhod7 raboten].[], [vhod7 raboten].[ ()], [vhod7 raboten].[, , ], [vhod7 raboten].[]
    FROM [vhod7 raboten]
    WHERE ((([vhod7 raboten].[])=""))
    ORDER BY [vhod7 raboten].[, , ];
    .

    .
    - - .
    .
    >8.00. 7.30-9.30.
    <17.00. 16.30-18.30.
    SQL ?

    SELECT distinct [vhod7 raboten].[ID], [vhod7 raboten].[No], [vhod7 raboten].[], min( [vhod7 raboten].[], [vhod7 raboten]).[ ()], [vhod7 raboten].[, , ], [vhod7 raboten].[]
    FROM [vhod7 raboten]
    WHERE ((([vhod7 raboten].[])=""))
    ORDER BY [vhod7 raboten].[, , ]
    GROUP BY [vhod7 raboten].[, , ]

    ?
    Last edited by entium; 17th August 2022 at 15:31.
    EP43-DS3|E5200@3.33|ASUS EN9800GT HB /HTDI/ 512MB|2X2GB 800MHZ CL5 A-DATA|WD2500JB|NEC 4750A|BELINEA 1980S2

  2. #2
    Registered User myrshavija's Avatar
    Join Date: Aug:2005
    Location:
    Posts: 3,062
    GROUP BY , - min, max ...
    .

  3. #3
    Registered User
    Join Date: May:2019
    Location: Burgas
    Posts: 1,247
    sql , .

  4. #4

  5. #5
    Registered User
    Join Date: Jan:2005
    Location:
    Posts: 242
    @entium, , quick and dirty - http://sqlfiddle.com/#!18/b9e2ff/2

    - , . common table expression case when , . view .

  6. #6
    Registered User entium's Avatar
    Join Date: May:2003
    Location:
    Posts: 1,426


    SELECT , Count(Mindate)
    FROM
    (SELECT , MIN() as Mindate
    FROM Vhod7
    GROUP BY )
    EP43-DS3|E5200@3.33|ASUS EN9800GT HB /HTDI/ 512MB|2X2GB 800MHZ CL5 A-DATA|WD2500JB|NEC 4750A|BELINEA 1980S2

  7. #7
    Registered User leionel's Avatar
    Join Date: Dec:2020
    Location: /
    Posts: 115

    SQL

    ,

    , , .

    , - - - , .

    .
    Last edited by leionel; 20th August 2022 at 18:42.

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 |