Third day of training for the Oracle (ZIBO) test staff

This time I'm going to write it down!

November 4, the first exam, the content of the exam is about the MySQL query command, the test of a morning, took the question to a face, not kidding, I thought the problem will be very simple! The result is I think too much ....

Give some examples:

Identify all people with the same native origin as "Qin Yi" (Qin Yi: MMP)

SELECT * from Stu where jg= (select JG from Stu where name= "Qin Yi");

Find out the department information of Hebei People (Hebei people strongly condemn)

SELECT * from Yxinfo where id= (select Yxid from Stu where jg= "Hebei");

Find information about all students in the same department as Fujian girls (Fujian girls are eaten by Cantonese)

SELECT * from Stu where yxid= (select Yxid from Stu where jg= "Fujian" and sex= "female");

Have to say there are many places to learn, these things if not often look, want to remember the real difficulties, let alone master

Again, the code to write a two of the problem is not big, but put a bunch in front of me ... I have to admit, I may be suffering from intense phobia. _ (: З"∠) _

Third day of training for the Oracle (ZIBO) test staff