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 vote191 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
1 vote155 views1 answer
Restart identity postgresql
SQL
2 votes174 views3 answers
How to get second highest salary in each department in sql
SQL
5 votes156 views3 answers
Postgres show databases
SQL
3 votes160 views3 answers
How to add month in update sql
SQL
0 vote165 views2 answers
Plsql function that return a table
SQL
0 vote185 views1 answer
Get total and distict row diff in sql
SQL
0 vote197 views1 answer
Which lock mode is not available in sql
SQL
1 vote200 views1 answer
Ora-01109 database not open in oracle 19c
SQL
1 vote167 views1 answer
Postgresql escape single quote
SQL