Databases
StackOverflow2013
Postsdbo
POplease check my MYSQL query & give me advice?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POplease check my MYSQL query & give me advice?
    text
    copied!<p>this is my mysql query.</p> <pre><code>SELECT s.s_nric AS nric, s.s_name AS name, s.s_psle_eng AS psle_eng, s.s_psle_math AS psle_maths, s.s_psle_aggr AS psle_aggr, (SELECT re.re_mark FROM si_results re WHERE re.re_code LIKE 'FEEN%' AND re.re_year = '2008' AND re.re_semester = '2' AND re.re_nric = s.s_nric) AS english_2008, (SELECT re.re_mark FROM si_results re WHERE re.re_code LIKE 'FEMA%' AND re.re_year = '2008' AND re.re_semester = '2' AND re.re_nric = s.s_nric) maths_2008, (SELECT re.re_mark FROM si_results re WHERE re.re_code LIKE 'FEEN%' AND re.re_year = '2009' AND re.re_semester = '2' AND re.re_nric = s.s_nric) AS english_2009, (SELECT re.re_mark FROM si_results re WHERE re.re_code LIKE 'FEMA%' AND re.re_year = '2009' AND re.re_semester = '2' AND re.re_nric = s.s_nric) maths_2009, isc.isc_g_gpa AS isc_gpa FROM si_student_data AS s LEFT JOIN si_isc_gpa AS isc ON isc.isc_g_nric = s.s_nric WHERE 1 = 1 AND s.s_admission_year = '2008' GROUP BY s.s_nric ORDER BY s.s_gender, s.s_name ASC </code></pre> <p>please check my sub query</p> <p>this is my sub query</p> <pre><code>(SELECT re.re_mark FROM si_results re WHERE re.re_code like 'FEEN%' AND re.re_year='2008' AND re.re_semester='2' AND re.re_nric=s.s_nric) as English_2008, (SELECT re.re_mark FROM si_results re WHERE re.re_code like 'FEMA%' AND re.re_year='2008' AND re.re_semester='2' AND re.re_nric=s.s_nric) Maths_2008, (SELECT re.re_mark FROM si_results re WHERE re.re_code like 'FEEN%' AND re.re_year='2009' AND re.re_semester='2' AND re.re_nric=s.s_nric ) as English_2009, (SELECT re.re_mark FROM si_results re WHERE re.re_code like 'FEMA%' AND re.re_year='2009' AND re.re_semester='2' AND re.re_nric=s.s_nric ) Maths_2009 </code></pre> <p>When I execute my query, server take long time to execute. So how to make simple? please advice me.</p> <p>Thanks.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload