Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Top 2 Query
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Clojure
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Rust
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
DROP TABLE IF EXISTS my_table; CREATE TABLE my_table (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,my_type CHAR(1) NOT NULL ,created DATE NOT NULL ); INSERT INTO my_table VALUES ( 1,'A','2017-04-09'), ( 2,'C','2017-04-09'), ( 3,'D','2017-04-09'), ( 4,'A','2017-04-12'), ( 5,'A','2017-07-09'), ( 6,'A','2017-11-08'), ( 7,'C','2017-05-09'), ( 8,'C','2017-09-12'), ( 9,'C','2017-10-01'), (10,'B','2017-04-09'), (11,'D','2017-05-17'); SELECT x.* FROM my_table x JOIN my_table y ON y.my_type = x.my_type AND y.id <= x.id AND y.created >= '2017-04-10' WHERE x.created >= '2017-04-10' GROUP BY x.id HAVING COUNT(*) <= 2;
absolute service time: 0,42 sec
edit mode
|
history
|
discussion
id
my_type
created
1
4
A
12.04.2017 00:00:00
2
5
A
09.07.2017 00:00:00
3
7
C
09.05.2017 00:00:00
4
8
C
12.09.2017 00:00:00
5
11
D
17.05.2017 00:00:00