If two columns are 1 then make new column

by

Your query would be:

SELECT PRESENT, WHOLEDAY,
       CASE
           WHEN  (PRESENT = 1 AND WHOLEDAY = 1) THEN 1
           WHEN  (PRESENT = 1 AND WHOLEDAY = 0) THEN 0.5
           ELSE  0
       END as ATTENDANCE 
FROM MY_TABLE

Case Syntax is :

CASE
    WHEN condition_1 THEN commands
    WHEN condition_2 THEN commands
    ...
    ELSE commands
END CASE;

More Related Contents:

  1. i have an error which i dont understand. can you help me? [closed]
  2. MySQL : isn’t in GROUP BY
  3. MySQL: Can’t create table (errno: 150)
  4. Restore table structure from frm and ibd files
  5. Subqueries with EXISTS vs IN – MySQL
  6. Error Dropping Database (Can’t rmdir ‘.test\’, errno: 17)
  7. Composite key as foreign key (sql)
  8. #1292 – Incorrect date value: ‘0000-00-00’ [duplicate]
  9. mySQL query to search all tables within a database for a string?
  10. SQL Query needed for fetch value from Two identical table but not fully identical table
  11. How can I SELECT rows with MAX(Column value), PARTITION by another column in MYSQL?
  12. Can I concatenate multiple MySQL rows into one field?
  13. How to do the Recursive SELECT query in MySQL?
  14. MySQL, update multiple tables with one query
  15. SQL Performance UNION vs OR
  16. How do I use on delete cascade in mysql?
  17. Adding a leading zero to some values in column in MySQL
  18. Using SQL to determine word count stats of a text field
  19. Update one MySQL table with values from another
  20. How to transpose mysql table rows into columns
  21. MySQL Group By and Sum total value of other column
  22. Regaining access to lost MySQL password for PHPMyAdmin on WAMP
  23. MySQL incorrect key file for tmp table when making multiple joins
  24. Does the order of conditions in a WHERE clause affect MySQL performance?
  25. Difference between these two joining table approaches?
  26. MySQL query, MAX() + GROUP BY
  27. MySQL export into outfile : CSV escaping chars
  28. Simple Random Samples from a MySQL Sql database
  29. ALTER table – adding AUTOINCREMENT in MySQL
  30. MySQL Select minimum/maximum among two (or more) given values

Leave a Comment