Member Avatar for sivak

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

  • 2 Contributors
  • 3 Replies
  • 71 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by nmaillet
Member Avatar for sivak

can anyone tell me the query...urgent plz

Member Avatar for nmaillet

You usually won't get a response unless you put in some effort.

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.