Small update to SQL query
- Status: Closed
- Prize: £10
- Entries Received: 8
- Winner: dtrighatia
Contest Brief
I need a small update to my already existing SQL query.
Task is if a company comes in 2017 and skips 2018, then comes in 2019, they should be counted as YEAR1 rather than YEAR2. In short, if any company skips a year, they should be treated as fresh company in the following year if they come.
Please download the attached sql file, where the table and data is given, also the query is given. The query was basically skipping any missing year for a company and was incrementing the year reargless.
Recommended Skills
Employer Feedback
“Was professional”
wolfmat, United Kingdom.
Top entries from this contest
-
worksmartt India
-
FreeDeveloperNl Netherlands
-
abdulrazakZakieh Turkey
-
suktvm United Arab Emirates
-
screenname1 India
-
screenname1 India
-
abdulrazakZakieh Turkey
Public Clarification Board
How to get started with contests
-
Post Your Contest Quick and easy
-
Get Tons of Entries From around the world
-
Award the best entry Download the files - Easy!