Code: Select all
SELECT * FROM weekly_rankings WHERE team = 'islanders' AND week = 3Code: Select all
select * from weekly_rankings where
team ='islanders' and week = (select max (week) from weekly_rakings)Moderator: General Moderators
Code: Select all
SELECT * FROM weekly_rankings WHERE team = 'islanders' AND week = 3Code: Select all
select * from weekly_rankings where
team ='islanders' and week = (select max (week) from weekly_rakings)Code: Select all
SELECT * FROM weekly_rankings WHERE team = 'islanders' ORDER BY week DESC LIMIT 1