8 people are registered for an online course, but only the first 4 of them are able to participate.

Question

Please answer this question for me thanks
I insert :
Select * from apartment
Where limit 4
But its wrong and has error please help me that where is my mistake❤

Answer 1

Sandeep Kushwaha it doesnt work😐

Answer 2

Andrew Choi it was true thanks

Answer 3

Post your attempt first

Answer 4

Sandeep Kushwaha SELECT FROM Participants;
WHERE LIMIT 4;
the name of table is Participants

Answer 5

i think you just need to order by registration date. so your code could look something like this:

SELECT *
FROM participants
ORDER BY registration_date
LIMIT 4;

Answer 6

glad that worked.

Answer 7

this how i can solve it : select Participants.firstname,Participants.lastname
from Participants
limit 4;

saludos de Mex

Answer 8

SELECT *
FROM participants
LIMIT 4;

Answer 9

SELECT Participants.firstname,Participants.lastname
FROM Participants
LIMIT 4;