fork download
copy 
  1. -- your code goes here
  2. CREATE TABLE Salaries(
  3. CheckNum INTEGER PRIMARY KEY,
  4. Amount DECIMAL(8,2) NOT NULL
  5. );
  6.  
  7. insert into Salaries (CheckNum,Amount)
  8. values (1123,12000),(1232,12000),(14,34),(13,34),(12,12003),
  9. (67,12004),(1,35),(23,36),(24,37),(34,38),
  10. (118,222);
  11.  
Success #stdin #stdout 0s 3452KB
comments (?)
stdin
copy 
Select amount,count(*) as counter from Salaries group by amount having counter =(Select max(result) as maximum from (select count(amount) as Result from 
Salaries group by amount order by amount desc));
stdout
copy 
34|2
12000|2
https://ideone.com/TJtJI8
language:
SQLite (sqlite 3.27.2)
created:
7 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!