/SQL/Select if then postgresql

Select if then postgresql

Select if then postgresql

SELECT field1, field2,
  CASE
    WHEN field1>0 THEN field2/field1
    ELSE 0
  END 
  AS field3
FROM test

1

Source: stackoverflow.com

Similar codes

3 votes288 views2 answers
How to start postgresql on windows
SQL
0 vote323 views1 answer
Get statis values sql
SQL
0 vote292 views1 answer
Oracle activate program
SQL
4 votes279 views1 answer
Oracle user tables
SQL
0 vote297 views1 answer
Edit a field mysql terminal
SQL
1 vote389 views1 answer
Aqua Data studio postgresql ssl
SQL
6 votes285 views2 answers
Mysql set primary key
SQL
1 vote277 views1 answer
Psql connect to another database
SQL
0 vote292 views1 answer
Oracle shrink table
SQL
1 vote291 views1 answer
Drop df constraint sql server
SQL

Share