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

0 vote164 views1 answer
Postgres execute multiple sql file from command line
SQL
1 vote75 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
0 vote128 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote133 views1 answer
Query params sql insert python f string
SQL
0 vote144 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
0 vote131 views1 answer
Java nosql sort
SQL
0 vote124 views1 answer
Get employees if not contains in sql
SQL
3 votes127 views3 answers
Remove all spaces from string sql
SQL
0 vote140 views1 answer
Sql order by except one row
SQL
12 votes129 views1 answer
How to change the value of a table in sql
SQL