Listing later dates in comparison to another entry in SQL

Question

How would I list the students who started later than start year of student with id = 8871?

This is what I have so far:

SELECT sid s1
FROM Student
WHERE s1.started <= sid = '8871';

I went to this link for some reference but I'm still having issues: Query comparing dates in SQL

Student Table has: Student (Lastname, Firstname, SID, Started)

any help would be great

See http://meta.stackoverflow.com/questions/333952/why-should-i-provide-an-mcve-for-what-seems-to-me-to-be-a-very-simple-sql-query — Strawberry, Oct 13 '16 at 16:42

score 1 · Accepted Answer · edited Sep 19 '17 at 06:56

1

I'd use a self join where one side of the join contains the students you want and the the reference student 8871:

SELECT a.*
FROM   student a
JOIN   student b ON b.sid = '8871' AND a.started  > b.started

edited Sep 19 '17 at 06:56

CL.

answered Oct 13 '16 at 16:29

Mureinik

1

Thanks for linking the self join, im still new to this! – yeny314 Oct 13 '16 at 16:51

1 Answers1