[]
SQL En cok kayitin oldugu tarihi bulmak
Elimizde su sekilde bir database table olsa en cok kayit girilen günü sql query ile nasil bulabiliriz?
ID Name Surname Date
1 X y 10.01.2020
2 X y 10.01.2020
3 X y 10.01.2020
4 X y 10.01.2020
5 X y 08.02.2020
6 X y 09.02.2020
7 X y 01.03.2020
8 X y 15.03.2020
9 X y 15.03.2020
ID Name Surname Date
1 X y 10.01.2020
2 X y 10.01.2020
3 X y 10.01.2020
4 X y 10.01.2020
5 X y 08.02.2020
6 X y 09.02.2020
7 X y 01.03.2020
8 X y 15.03.2020
9 X y 15.03.2020
SELECT top 1 Date, count(1) as adet
FROM table1
group BY Date
order by adet desc
FROM table1
group BY Date
order by adet desc
- surprise (11.01.21 17:26:27)
1