952
try this
select studId, courseId, max(yearTaken), grade, count(courseid) as no_of_times from table group by studId, courseId
950
948
94 6
946
Why you need YEAR if try to display all the failures ?
Does the same course id repeats across all the years ?
9 4 6
You need to use DELETE to delete records. Use proper where clause for the same.
If you want to delete all the records simply use DELETE without any WHERE clause.
I don't think TRUNCATE is supported in ACCESS.
936
9 2 2
920
906
better to ask from whom you got this .
908
9 0 8
You need to read this.
90 8
You need to join both the tables using SQL if tables are related.
Why two separate tables for managers and clerks ?
904
900
898
902
910
914
You need to store the path of the file stored in the folders along with other details in the employee table.
To retrieve the same yo need to fetch the path stored in the DB and read the file from file systems.
Yes.
post your code here, i will fix it.
Using stored procedure is a better option than executing raw SQL.
836
even better if i flip. :)
8 3 6
Yes you need to use Dynamic SQL.
Try this sample or this.
by writing SQL the way i have already suggested earlier.
