Hi, I wanna know how we can respect the condition of " the same day" on queries in SQL ? | Sololearn: Learn to code for FREE!

+2

Hi, I wanna know how we can respect the condition of " the same day" on queries in SQL ?

It's the question : choose the people who have been invited for the interview for various posts in the same day !

10/26/2021 12:20:33 PM

Marzieh NOROUZI

9 Answers

New Answer

+2

Can you describe the table structure please? I think it's necessary to know that before giving any suggestion ...

+1

Table `entretien` does not have a column named no_candidature, why you have "ON candidature.no_candidature = entretien.no_candidature" I'm not sure I understand what you're trying to do with the GROUP BY and HAVING there. I would probably try to check candidature.date_candidature = entretien.date_entretion For the JOIN condition ...

+1

Sorry I forgot to write no_candidature In the entretien table ! I'm gonna try your solution , thank you so much !

+1

The group by And having is for another condition ! 😬

+1

Okay I wish you best of luck 👍

+1

Use the system date in MM/DD/YYYY format as a filter in the WHERE clause.....

0

You're right , But it's in french ,i hope that it's ok for you ! These are my two tables that I guess I have to make a JOIN in order to have the result: Table 1 candidature (No_candidature,Date_candidature,No_poste_No_candidat) Table 2 Entretien (no_entretien,date_entretien, durée_entretien)

0

I wrote : Select No_candidat From candidature join entretien on candidature.no_candidature = entretien.no_candidature Group by No_candidat Having count(No_poste) > 1 ;

0

But I don't know how to put the condition of " at the same day " here , how can I limit the various posts in the same day? For example : 3 posts in 26/2/2021