[prev in list] [next in list] [prev in thread] [next in thread] 

List:       odtug-sqlplus-l
Subject:    SQL: Selecting Single Row for Each Deptno
From:       "Zahid Khan" <zahiddocs1 () gmail ! com>
Date:       2007-09-14 9:40:38
Message-ID: F001.0060FB8F.20070914014038 () fatcity ! com
[Download RAW message or body]

Hi,

I am looking for a query which returns only one row per deptno from emp
table.

any help???

Thanks
Zahid

[Attachment #3 (text/html)]

<p>Hi,<br>&nbsp;<br>I am looking for a query which returns only one row per deptno \
from emp table.<br>&nbsp;<br>any help???</p> <p>Thanks<br>Zahid</p>


-- 
For more information on this topic or to become a member, visit our web site at \
http://www.ODTUG.com  Be sure to check out our Seriously Practical (SP) Conferences \
coming up this year! 

OPP2007 East - Oracle PL/SQL Training - September 18-19, 2007
http://www.odtugopp.com

-- 
Author: Zahid Khan
  INET: zahiddocs1@gmail.com

Fat City Hosting, San Diego, California -- http://www.fatcity.com
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic