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

Question

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

Answer 1

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

Answer 2

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

Answer 3

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 ...

Answer 4

Sorry I forgot to write no_candidature In the entretien table !

I'm gonna try your solution , thank you so much !

Answer 5

The group by And having is for another condition ! 😬

Answer 6

Okay I wish you best of luck 👍

Answer 7

eid esal. o/p

10 $3000. eid. esal
20. #4000. 10. 3000
30. *7000. 20. 4000
30. 7000. please write query

Answer 8

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)

Answer 9

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 ;

Answer 10

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