I have a table names 'scoredata' having fields id, lessonid, levelid, studentid, addedate in which score for each day will be entered by the admin. I want to select only those studentid whose score has not been added from last four weeks. How can I do this in a single query.
Make sure you index
Give it a Try !!!