Hi! Could we please enable some services and cookies to improve your experience and our website?

SQLize | PHPize | SQLtest

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

A A A
Login    Share code      Blog   FAQ
Copy Format Clear
create table emp220 (empno numERIC(10) primary key, ename char(30), salary numERIC(10), deptno numERIC(10) not null, dname char(20)); insert into emp220 values(11,'shIVAM',150000,101,'manager'); insert into emp220 values(12,'aKTAR',100000,102,'HR manager'); insert into emp220 values(13,'ajay',250000,103,'regional head'); insert into emp220 values(14,'rahul',15000,104,'peon'); insert into emp220 values(15,'harSH',20000,105,'content head'); select* from emp220 select* from emp220 where salary=(select max(salary) from emp220);

Stuck with a problem? Got Error? Ask AI support!

Copy Clear