Tag: SQL Subquery
-
Oracle Subquery
Subquery is a query with in a query.Syntax:-select * from table_name where column_name in (select column from table_name) Highlighted part is called Subquery. Examples:- Consider below table structures. DEPT table Deptno Deptname Location 1 HR London 2 Marketing Newyork 5 Management Bejing EMP table Empno Empname Salary Deptno 10 Bill 12000 5 11 Solomon 10000 5 12 Susan […]