SELECT DISTINCT std_no
FROM exam
WHERE POINT IN ('A','B');
At 12:00 AM 5/22/2001 -0800, you wrote:
>Dear gurus,
>
>I have a table :
>Tabel Exam
>STD_NO SUBJECT POINT
>====== ======= =====
>001 CHEM A
>001 PHYSIC A
>001 BIOLOGY A
>
>002 CHEM A
>002 PHYSIC B
>002 BIOLOGY A
>
>003 CHEM A
>003 PHYSIC A
>003 BIOLOGY B
>
>What is the SQL query to retrieve STD_NO which have CHEM = A and PHYSIC = A?
>
>The output should be :
>STD_NO
>======
>001
>003
>
>TIA,
>
>Ahmadsyah Alghozi Nugroho
>Database Engineering Specialist
>PT Infoglobal AutOptima
>Jl. Baruk Tengah I/49
>Surabaya - Jawa Timur
>INDONESIA
>phone : +62 (31) 8708456 ext.113
>visit [ORAID!] <http://oraid.iwarp.com>http://oraid.iwarp.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alex B. Cheng
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-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).