CODEWITHSUNDEEP
sqlsql-serverdb2derivedoptional-values
Lovely Kolli
Lovely Kolli

Reputation: 1

SQL derived value by a set of Row

Hi my table looks like this

1

Combination of Rows with same S id is termed as a family. Output should have a Calculated Tier code based on below derivation

Output put should be Output

First time i am using Stackoverflow. I need a query in db2 and I can use the output as a report.

Upvotes: -2

Views: 144

Answers (1)

Popeye
Popeye

Reputation: 35900

You need windows function as follows:

Select t.*,
       Concat('Tier ', count(*) over (partition by s_id) ) as tier
  From your_table t

Upvotes: 0

Related Questions