P
P
Prosghvatn2017-01-24 18:03:00
MySQL
Prosghvatn, 2017-01-24 18:03:00

How to set time interval during spring in PHPmyAdmin SQL database?

How to set the spring time interval in the line
(stud.Data) = MONTH(3) ? SELECT `stud`.Name, `stud`.NumS, `stud`.Data, `stud`.Fakult, `stud`.Kurs, `stud`.E1, `stud`.E2, `stud`.E3, ` stud`.Stip FROM `stud` INNER JOIN (SELECT MAX(stud.Data) AND MONTH (stud.Data) = MONTH(3) AS average FROM `stud` INNER JOIN `rob_gurt` ON `rob_gurt`.`NumS` = `stud`.`NumS` INNER JOIN `gurt` ON `gurt`.`NumG` = `rob_gurt`.`NumG` WHERE `stud`.`Fakult` = "Math") AS q ON `stud`.`Stip ` > q.average Display information about students who were born in the spring and receive a scholarship greater than that of a senior math student.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Dmitry Bay, 2017-01-24
@kawabanga

Head -on option -
(stud.Data) in (MONTH(3),MONTH(4),MONTH(5) )

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question