Results 1 to 7 of 7
Thread: SQL
Hybrid View
-
17th August 2022 13:43 #1
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
-
17th August 2022 15:47 #2
-
17th August 2022 16:54 #3Registered User
Join Date: May:2019
Location: Burgas
Posts: 1,247
sql , .
-
18th August 2022 13:05 #4Registered User
Join Date: Jan:2005
Location:
Posts: 242
-
19th August 2022 14:59 #5Registered User
Join Date: Jan:2005
Location:
Posts: 242
@entium, , quick and dirty - http://sqlfiddle.com/#!18/b9e2ff/2
- , . common table expression case when , . view .
-
20th August 2022 15:34 #6
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
-
20th August 2022 18:35 #7
SQL
,
, , .
, - - - , .
.Last edited by leionel; 20th August 2022 at 18:42.




Reply With Quote

LOG
06.05.23 ., 12:03 in