Question

Best way to create a conditional SQL query? CASE, DECODE, or IF/THEN?

score 60 · Answer 1 · 2024-03-27T15:58:12.763000

60

Views

Best way to create a conditional SQL query? CASE, DECODE, or IF/THEN?

Published on 27 March 2024 at 15:58

score 61 · Answer 2 · 2024-03-27T15:50:38.283000

61

Views

How to use CASE condition in WHERE in PostgreSQL?

Published on 27 March 2024 at 15:50

score 77 · Answer 3 · 2024-03-27T15:28:59.200000

77

Views

How to use a conditional to evaluate a paired variable in case statement

Published on 27 March 2024 at 15:28

score 37 · Answer 4 · 2024-03-27T08:16:39.540000

37

Views

counting items in a nested structure

Published on 27 March 2024 at 08:16

score 56 · Answer 5 · 2024-03-26T17:01:24.253000

56

Views

SQL How to add a conditional to the aggregate function within a pivot table?

Published on 26 March 2024 at 17:01

score 54 · Answer 6 · 2024-03-26T16:10:11.787000

54

Views

Combine multiple values into one field using CASE statement

Published on 26 March 2024 at 16:10

score 46 · Answer 7 · 2024-03-25T15:45:13.587000

46

Views

SQL conditional select and conditional where

Published on 25 March 2024 at 15:45

score 36 · Answer 8 · 2024-03-25T15:40:18.353000

36

Views

using case_when across multiple columns to calculate difference in time

Published on 25 March 2024 at 15:40

score 44 · Answer 9 · 2024-03-22T15:51:43.150000

44

Views

How do I Join two SQL tables on Multiple date columns

Published on 22 March 2024 at 15:51

score 27 · Answer 10 · 2024-03-20T21:35:06.400000

27

Views

Nested MySQL Statement Issue

Published on 20 March 2024 at 21:35

score 96 · Answer 11 · 2024-03-19T21:12:37.393000

96

Views

Return more than one int value

Published on 19 March 2024 at 21:12

score 83 · Answer 12 · 2024-03-19T20:15:34.587000

83

Views

Reuse Case statement calculation in select Query

Published on 19 March 2024 at 20:15

score 20 · Answer 13 · 2024-03-18T19:00:36.770000

20

Views

Django ORM: Case When not working when output is a Subquery producing a list of Ids?

Published on 18 March 2024 at 19:00

score 44 · Answer 14 · 2024-03-18T05:39:12.203000

44

Views

Type '(any Error)?' has no member 'success'

Published on 18 March 2024 at 05:39

score 15 · Answer 15 · 2024-03-15T00:09:08.157000

15

Views

PSQL: add case / if statement to `returning` statement

Published on 15 March 2024 at 00:09

score 39 · Answer 16 · 2024-03-13T02:00:06.937000

39

Views

KQL How to display default rows for every case even on no match

Published on 13 March 2024 at 02:00

score 39 · Answer 17 · 2024-03-12T14:09:49.753000

39

Views

receiving: ERROR: more than one row returned by a subquery used as an expression

Published on 12 March 2024 at 14:09

score 46 · Answer 18 · 2024-03-11T11:40:02.977000

46

Views

SQL - sum entire column without group by and create a new column which is grouped

Published on 11 March 2024 at 11:40

score 32 · Answer 19 · 2024-03-07T20:59:05.320000

32

Views

HSQLDB script file formatting

Published on 07 March 2024 at 20:59

score 55 · Answer 20 · 2024-03-05T08:52:21.333000

55

Views

issue with case statement

Published on 05 March 2024 at 08:52

List Question

Best way to create a conditional SQL query? CASE, DECODE, or IF/THEN?

How to use CASE condition in WHERE in PostgreSQL?

How to use a conditional to evaluate a paired variable in case statement

counting items in a nested structure

SQL How to add a conditional to the aggregate function within a pivot table?

Combine multiple values into one field using CASE statement

SQL conditional select and conditional where

using case_when across multiple columns to calculate difference in time

How do I Join two SQL tables on Multiple date columns

Nested MySQL Statement Issue

Return more than one int value

Reuse Case statement calculation in select Query

Django ORM: Case When not working when output is a Subquery producing a list of Ids?

Type '(any Error)?' has no member 'success'

PSQL: add case / if statement to `returning` statement

KQL How to display default rows for every case even on no match

receiving: ERROR: more than one row returned by a subquery used as an expression

SQL - sum entire column without group by and create a new column which is grouped

HSQLDB script file formatting

issue with case statement

Trending Questions

Popular # Hahtags

Popular Questions