StackOverflow Questions for Tag: conditional-aggregation

Prabha Christ
Prabha Christ

Reputation: 141

For one employee, In time and Out time should be returned on one line

Score: -1

Views: 31

Answers: 1

Read More
Katty_one
Katty_one

Reputation: 351

Calculating ratios in postgresql

Score: 1

Views: 244

Answers: 2

Read More
TingL
TingL

Reputation: 51

How can I get the total count and the count with the condition in the same SQL query?

Score: 1

Views: 94

Answers: 1

Read More

I need to get the average of 2 SQL query results in ASP.NET C#

Score: 1

Views: 34

Answers: 1

Read More
jackomelly
jackomelly

Reputation: 543

MySQL count percentual of occurrences greater than

Score: 1

Views: 45

Answers: 2

Read More
user18472331
user18472331

Reputation:

group by in queries that contains subqueries

Score: 0

Views: 54

Answers: 3

Read More
Ale
Ale

Reputation: 115

Counting records based on conditions over potential null values

Score: 1

Views: 77

Answers: 1

Read More
Pronto
Pronto

Reputation: 179

How to return 0 for all time intervals instead of nothing when counting

Score: 1

Views: 91

Answers: 2

Read More
User_K47
User_K47

Reputation: 65

How to get the sum of column in Table2 where table1 meet condition

Score: 1

Views: 71

Answers: 2

Read More
Jimski
Jimski

Reputation: 944

Is there a way to convert a query contianing multiple subqueries fetching the same column from same table, into one query

Score: 0

Views: 51

Answers: 1

Read More
GTAMN
GTAMN

Reputation: 11

Concatenate multiple strings ordered (PIVOT)

Score: 0

Views: 1508

Answers: 1

Read More
zeroes_ones
zeroes_ones

Reputation: 191

SQL: how to get sum of grouped items for a given corhort

Score: 0

Views: 86

Answers: 2

Read More
jee
jee

Reputation: 13

Shorten queries with multiple joins

Score: 0

Views: 50

Answers: 1

Read More
HJA24
HJA24

Reputation: 412

Use multiple INNER JOINS to transpose one column in multiple columns

Score: 2

Views: 96

Answers: 2

Read More
Sourav
Sourav

Reputation: 17530

MySql query to find difference between same column with condition

Score: 0

Views: 210

Answers: 2

Read More
Ikthezeus
Ikthezeus

Reputation: 105

MySQL iterate information from one table in to 2 columns in query

Score: 0

Views: 27

Answers: 0

Read More
Kalyan
Kalyan

Reputation: 1940

Generating a table of subtraction of two colum count

Score: 1

Views: 46

Answers: 1

Read More
Grendizer
Grendizer

Reputation: 2213

SQL query output results from one table into two columns

Score: 1

Views: 86

Answers: 1

Read More
Ricardo Luiz Vieira
Ricardo Luiz Vieira

Reputation: 13

Filter as count on SQL SERVER

Score: -1

Views: 68

Answers: 2

Read More
Irfan
Irfan

Reputation: 61

filter `id` with a specified value in another column and it does not appear more than once on each `id`

Score: 1

Views: 41

Answers: 2

Read More
PreviousPage 1Next