Home » SQL & PL/SQL » SQL & PL/SQL » Subquery in where clauses
Subquery in where clauses [message #308584] Tue, 25 March 2008 00:08 Go to next message
tondapi
Messages: 99
Registered: August 2007
Location: usa
Member
how can we write subquery in where classes?

please give any example?
Re: Subquery in where clauses [message #308591 is a reply to message #308584] Tue, 25 March 2008 00:21 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
select * 
from   emp
where  ename = 'subquery';


What did you expect? You tell us where you looked, what you found and then what you did not understand.
Re: Subquery in where clauses [message #308598 is a reply to message #308584] Tue, 25 March 2008 00:52 Go to previous message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database SQL Reference
Chapter 9 SQL Queries and Subqueries

Regards
Michel
Previous Topic: Complex Case Expression
Next Topic: Example for only clause?
Goto Forum:
  


Current Time: Fri Dec 02 12:23:49 CST 2016

Total time taken to generate the page: 0.10726 seconds