da axe man
da axe man

Reputation: 29

SQL query using if else

My SQL code looks like this:

SELECT 
    Scores.PupilId, Scores.BoysName, Scores.FormGroup,
    IF (Scores.FormGroup = "10SB", "Great", "ok")
FROM 
    Scores

I get this message

no such function: if: SELECT Scores.PupilId, Scores.BoysName, Scores.FormGroup,
if(Scores.FormGroup="10SB","Great","ok")
FROM Scores

This is flat file database

Can anyone please help me understand why I am getting a message?

Upvotes: 1

Views: 70

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1270663

The correct ANSI-standard conditional expression in SQL is the case expression:

SELECT Scores.PupilId, Scores.BoysName, Scores.FormGroup,  
       (CASE WHEN Scores.FormGroup = '10SB' THEN 'Great' ELSE 'ok' END)
FROM Scores ;

Upvotes: 2

Related Questions