fork download
copy 
  1. CREATE TABLE students(
  2.  student_id INT Primary Key,
  3.  student_name VARCHAR(40),
  4.  grade INT
  5. );
  6.  INSERT INTO students(student_id,student_name,grade)
  7.  VALUES
  8.  (1,'Alice',89),
  9.  (2,'Bob',99),
  10.  (3,'Luice',55),
  11.  (4,'Charlie',77),
  12.  (5,'Emaa',91);
  13.  SELECT student_id , student_name ,grade
  14.  FROM students
  15.  WHERE grade >= 90 AND grade <= 100;
Success #stdin #stdout 0s 5312KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
2|Bob|99
5|Emaa|91
https://ideone.com/p1U24G
language:
SQLite (sqlite 3.27.2)
created:
23 hours 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!