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