Search results

I'm trying to design a query in which a sum is derived from a subquery which should select top 2 Currently this sometimes produces more than 2 where there are ties eg Select top 2 from (12, 10, 10 )... this produces all three so the sum is 32 instead of what I need... 22 Sample DB Kind Regards

:banghead:I have problems understanding lookup tables, especially how to populate them with data. I'm working on an exams database, and have many such tables... Table for Students Table for Subjects and a lookuptable for studentsubjects Table for Classes 1, 2, 3, 4 Table for Subjects Eng...

Dear Experts, I'm quite new to design of databases. With much reading about database designs, normalizations and seeking help here and there, I've designed the table described by the tables below. Class/level (LevelD, LevelName, SchoolYrID fk to tblSchoolYrs) SchoolYears (SchYrID, YrStart...