Tag: SQL Subquery

• December 3, 2011

  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 […]