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 vote351 views1 answer
Mysql start of today
SQL
2 votes425 views5 answers
Tablespace ORACLE
SQL
0 vote368 views1 answer
Basic structure of sql expression having clause
SQL
4 votes329 views1 answer
Mysql biginteger size
SQL
2 votes372 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote359 views1 answer
How change the field place in mysql
SQL
1 vote351 views1 answer
Trigger in postgresql to change incoming entry
SQL
0 vote328 views1 answer
Mysql events not work
SQL
1 vote360 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
0 vote339 views1 answer
Create a PostgreSQL user django on mac
SQL