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

12 votes222 views6 answers
Distinct in sql server
SQL
0 vote193 views2 answers
How to display enum value sql server
SQL
0 vote201 views1 answer
Query only first letter string
SQL
0 vote204 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
0 vote183 views1 answer
Like sql for second letter of the family name
SQL
0 vote205 views1 answer
Mysqli last row
SQL
0 vote154 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
0 vote210 views1 answer
Mysql aspas simples
SQL
25 votes185 views1 answer
Mysql grant all privileges to a user
SQL
0 vote259 views3 answers
Select top 10 rows in sql
SQL