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 votes270 views2 answers
Stored procedure to delete data from table in mysql
SQL
0 vote251 views1 answer
Oracle index hint multiple tables example
SQL
0 vote277 views1 answer
Difference between min and max date sql
SQL
0 vote301 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
6 votes260 views3 answers
Mysql first day of year
SQL
0 vote260 views1 answer
Postgres select except
SQL
0 vote263 views1 answer
How to find unique key in sql
SQL
1 vote289 views1 answer
SQL query to get all table records count from a database
SQL
0 vote245 views1 answer
Mysql date + 1 day
SQL
0 vote269 views1 answer
How to find username and password in oracle 18c
SQL