I want to delete everything in the tables Students except the records
for the student with ID number = 1.
How can i do it ?
The code i tried and failed was :
Dim SQL As String
DELETE * FROM Students WHERE StudentID <>t 1 "
what i mean is that student is not = 1,but i do not know how to express it