example (SQL)

Sai_kiran_rachakonda · June 27, 2022

CREATE TABLE palette_a (
    id INT ,
    color VARCHAR2 (100),
    favcol int
);

INSERT INTO palette_a 
VALUES (1, 'Red', 792);

INSERT INTO palette_a 
VALUES (2, 'Green', 795);

INSERT INTO palette_a 
VALUES (3, 'Blue', 790);

select * from palette_a where favcol > (select min(favcol) from palette_a);

Output

Comments

Please sign up or log in to contribute to the discussion.