Small update to SQL query

  • Status: Pending
  • Hadiah: £10
  • Entri Diterima: 9
  • Pemenang: dtrighatia

Deskripsi Kontes

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.

Keahlian yang Disarankan

Entri teratas dari kontes ini

Tampilkan Entri Lainnya

Papan Klarifikasi Publik

  • abdulrazakZakieh
    abdulrazakZakieh
    • 5 hari yang lalu

    Please check my entrıes #8 and #1 .

    • 5 hari yang lalu
  • abdulrazakZakieh
    abdulrazakZakieh
    • 6 hari yang lalu

    Dear contest holder,
    The SQL code is ready as needed. You can see the results in my entry #1 . If there is any wrong with calculation, please tell me.

    • 6 hari yang lalu
  • abdulrazakZakieh
    abdulrazakZakieh
    • 6 hari yang lalu

    Dear contest holder,
    I can write a C# code to do the job if you are interested.
    I am working on a solution using SQL as well.
    If the C# code is good, I can give it to you in a short time.

    • 6 hari yang lalu

Bagaimana untuk memulai sebuah kontes

  • Buat kontes Anda

    Buat Kontes Anda Cepat dan mudah

  • Dapatkan jutaan entri

    Dapatkan Jutaan Entri Dari seluruh dunia

  • Pilih entri terbaik

    Pilih entri terbaik Unggah file - Mudah!

Buat sebuah Kontes Sekarang atau Gabung dengan kami Hari ini!