i have 3 tables
student table
roll no name
sub table
roll no subid subname
markstable
roll no subid marks
1)select name,subname,marks whose having marks less than 40
2)select sub name,marks whose having avg above 60%
3)select rank of each student
can any one tell me the query for that
sivak
-7
Junior Poster
Recommended Answers
Jump to PostHere is a pretty good tutorial on SQL http://w3schools.com/sql/default.asp
All 3 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.