Elance Exams Answers PDF file

-- PDF FILE --
Download PDF file of elance Zoho Creator Exam Answers
elance-zoho-creator-exam.pdf

Consider a table "Team" with the columns : {Teamname, Location, State, Wins, Losses, NetPoints}. If there are 10 rows in "Team" - one row for each team, whats the SQL code to retrieve the team(s) that scored the most points?

select Teamname from team where count(*) = max(netpoints)
select Teamname from team where count(*) = max(count(netpoints))
select Teamname from team where points = max(netpoints)
select Teamname from team where points = (select max(netpoints) from team)
Top
  • Follows us our servcies
  • Facebook icon
  • Linkedin icon
  • twitter icon
  • rss icon
  • social icon