Skip to content

Instantly share code, notes, and snippets.

@harsha547

harsha547/SQL_Query_5.sql

Created December 18, 2016 19:57
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save harsha547/49a40ea7217d79e097001e24662b3636 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save harsha547/49a40ea7217d79e097001e24662b3636 to your computer and use it in GitHub Desktop.
Download ZIP
Teams participated in Indian Premier League Database
Raw
SQL_Query_5.sql
-- Number of Teams participated in Indian Premier League Databse
SELECT RANK() OVER (ORDER BY Team_Name ) AS Serial_No ,Team.Team_Name
FROM Team
ORDER BY Serial_No
@harsha547
Copy link
Author

harsha547 commented Dec 18, 2016

Solution 👍

image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment