fork download
copy 
  1. CREATE TABLE myTable(id INT, val CHAR(3));
  2. INSERT INTO myTable VALUES (1, 'foo');
  3. INSERT INTO myTable VALUES (2, 'bar');
  4. INSERT INTO myTable VALUES (3, 'baz');
  5. INSERT INTO myTable VALUES (4, 'foo');
  6.  
  7. SELECT COUNT(DISTINCT val) FROM myTable;
Success #stdin #stdout 0s 3008KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
3
https://ideone.com/BDK6jo
language:
SQLite (sqlite 3.27.2)
created:
11 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!