SQL Query (conditional)

Question

I'm trying to query from an SQL table. I am having issues getting an if statement to work for a conditional thing I'm trying to achieve in the query.

If the deaths of the player = 0, I want the kd column (ratio) to be equal to kills, not NULL. Here is my current query, I have no clue how to take this.

SELECT name, time, map, kills, deaths, kills/deaths AS kd 
FROM history;

Logic I want:

if deaths = 0: kills/deaths = kills

Gordon Linoff · Accepted Answer · 2018-08-05 15:36:45Z

2

You can use a case expression:

SELECT name, time, map, kills, deaths,
       (case when deaths = 0 then kills else kills/deaths end) as kd 
FROM history;

Normally, to avoid divide by zero, it is sufficient for the result to be NULL. If this is what you really want, then NULLIF() is a better solution:

SELECT name, time, map, kills, deaths,
       ( kills / NULLIF(deaths, 0) ) as kd 
FROM history;

answered Aug 5, 2018 at 15:36

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3426499 Over a year ago

Thank you so much. The case expression was exactly what I'm looking for.

Dice · Accepted Answer · 2018-08-05 22:45:32Z

0

All you need is a WHERE clause you know.

And to make better statements when you insert in your database.

answered Aug 5, 2018 at 22:45

Dice

2351 silver badge9 bronze badges

Collectives™ on Stack Overflow

SQL Query (conditional)

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related