Nested query

select E.ename from employee E where E.eid IN (select S.eid from salary S where S.regno=103);

Source: tutorialspoint.com

Nested query

create table student(id number(10), name varchar2(20),classID number(10), marks varchar2(20));
Insert into student values(1,'pinky',3,2.4);
Insert into student values(2,'bob',3,1.44);
Insert into student values(3,'Jam',1,3.24);
Insert into student values(4,'lucky',2,2.67);
Insert into student values(5,'ram',2,4.56);
select * from student;

Source: tutorialspoint.com

Similar codes

6 votes132 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
0 vote148 views1 answer
Sql ignore
SQL
7 votes154 views2 answers
Where keyword sql
SQL
1 vote145 views1 answer
Altering the column name in MySQL to have a default value
SQL
0 vote151 views1 answer
Mysql insert into select with recursive
SQL
12 votes186 views6 answers
How to install sqlite3 in python
SQL
0 vote155 views1 answer
Psql check table fields
SQL
7 votes150 views1 answer
Grant schema permissions postgres
SQL
0 vote131 views1 answer
Alter table add foreign key mariadb example
SQL
0 vote141 views1 answer
Mysql streaming example
SQL