Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Help on query

Help on query

From: Ahmadsyah Algozhi Nugroho <aan_at_nwa.iao.co.id>
Date: Tue, 22 May 2001 00:34:00 -0700
Message-ID: <F001.0030A3C0.20010522003124@fatcity.com>

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 Received on Tue May 22 2001 - 02:34:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US