SNaRe's user avatar
SNaRe's user avatar
SNaRe's user avatar
SNaRe
  • Member for 4 years, 6 months
  • Last seen more than 1 year ago
3 votes
2 answers
15k views

Deleting all rows from INNER JOINed 3 different tables

3 votes
4 answers
936 views

Getting difference of a column between first and last row with count number

2 votes
3 answers
5k views

How to show a column as NULL if it doesn't exist in match?

2 votes
1 answer
260 views

Repating COUNT in WhereIN condition [duplicate]

1 vote
2 answers
522 views

Optimizing the query with 2 distinct counts in select

1 vote
1 answer
71 views

Getting both Having and Not Having in same row

1 vote
1 answer
2k views

How to get the row number when using alias in orderby

1 vote
1 answer
25 views

Counting number of total results for each column name

1 vote
1 answer
36 views

How to delist subset strings if it is a substring of another string

1 vote
1 answer
2k views

Getting specific key values from JSONB into columns

1 vote
1 answer
894 views

How to split a list of number into ranges with a fixed interval with SQL?

0 votes
1 answer
176 views

How to group by and count with mongodb?

0 votes
1 answer
232 views

How to extract values from a JSON field with Mongodb?

0 votes
1 answer
35 views

Search a string across all columns of a query result

0 votes
2 answers
100 views

Faster alternative to count value from 2 queries and select with WITH [closed]

0 votes
0 answers
183 views

How to optimize a query with select, row number and a lot of LIKE

0 votes
1 answer
194 views

Select count date from multiple where conditions for each day

0 votes
1 answer
72 views

Selecting the max date out of a text group

0 votes
1 answer
81 views

Count and sum, counted and summed values

0 votes
1 answer
122 views

Query with different time period in same query ( WHERE )

0 votes
2 answers
7k views

Getting sum of each day of last 30 days

-1 votes
1 answer
93 views

How to run where exists with distinct faster