Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
GKM_JOIN
create table student(s_id int primary key, s_name varchar(20)); insert into student values(1, 'Jack'); insert into student values(2, 'Rithvik'); insert into student values(3, 'Jaspreet'); insert into student values(4, 'Praveen'); insert into student values(5, 'Bisa'); insert into student values(6, 'Suraj'); create table marks(school_id int primary key, s_id int, score int, status varchar(20)); insert into marks values(1004, 1, 23, 'fail'); insert into marks values(1008, 6, 95, 'pass'); insert into marks values(1012, 2, 97, 'pass'); insert into marks values(1016, 7, 67, 'pass'); insert into marks values(1020, 3, 100, 'pass'); insert into marks values(1025, 8, 73, 'pass'); insert into marks values(1030, 4, 88, 'pass'); insert into marks values(1035, 9, 13, 'fail'); insert into marks values(1040, 5, 16, 'fail'); insert into marks values(1050, 10, 53, 'pass'); create table details(address_city varchar(20), email_ID varchar(20), school_id int, accomplishments varchar(50)); insert into details values('Banglore', 'jsingh@geeks.com', 1020, 'ACM ICPC selected'); insert into details values('Hyderabad', 'praveen@geeks.com', 1030, 'Geek of the month'); insert into details values('Delhi', 'rithvik@geeks.com', 1012, 'IOI finalist'); insert into details values('Chennai', 'om@geeks.com', 1111, 'Geek of the year'); insert into details values('Banglore', ' suraj@geeks.com', 1008, 'IMO finalist'); insert into details values('Mumbai', 'sasukeh@geeks.com', 2211, 'Made a robot'); insert into details values('Ahmedabad', 'itachi@geeks.com', 1172, 'Code Jam finalist'); insert into details values('Jaipur', 'kumar@geeks.com', 1972, 'KVPY finalist'); select *from student; select *from marks; select *from details; select s_name, score, status, address_city, accomplishments, email_ID from student inner join marks on student.s_id = marks.s_id inner join details on marks.school_id=details.school_id; select s_name,school_id,score,status from student s join marks m on s.s_id=m.s_id where m.status = 'pass' order by s.s_id; select *from student s right join marks m on s.s_id=m.s_id order by m.s_id; select *from student, marks; select *from details; select address_city, count(*) as duplicat from details group by address_city HAVING count(*) > 1; select s_id from student union select s_id from marks; select *from student s full join marks m on s.s_id=m.s_id full join details d on m.school_id=d.school_id where m.status='pass';
run
|
edit
|
history
|
help
0
table creation
SQL query to find difference in text between different rows
Sql Queries
DDL,DQL,DML
join
test
index fragmentation and how to deal with it
NAMES
employee table
Left join producing wrong result