|
What is the difference between ON (C1=C2 AND C3=C4) and ON (C1=C2 OR C3=C4)?
|
|
3
|
270
|
February 22, 2021
|
|
Passing dynamic column names an data in json to query with
|
|
4
|
5219
|
February 22, 2021
|
|
Do WHERE statements filter the pre-join tables or the after-join table?
|
|
9
|
8045
|
February 22, 2021
|
|
Buggy date comparison
|
|
2
|
233
|
February 21, 2021
|
|
Cannot use an aggregate or a subquery in an expression
|
|
3
|
370
|
February 21, 2021
|
|
Calculate days ahead for a date to know expiring password date
|
|
1
|
241
|
February 19, 2021
|
|
Need help with insert/update statement(Appeon Powerbuilder)
|
|
1
|
558
|
February 19, 2021
|
|
Is there a command to drop all temp tables when re-running the query?
|
|
4
|
5662
|
February 19, 2021
|
|
How can I store and reuse (1,2,3)?
|
|
20
|
396
|
February 18, 2021
|
|
Is it possible to store part of a query as a variable to reuse?
|
|
6
|
743
|
February 18, 2021
|
|
How to use 'IF' in a query
|
|
4
|
207
|
February 18, 2021
|
|
Is this strategy robust?
|
|
4
|
193
|
February 17, 2021
|
|
How to hide few digits of account number
|
|
3
|
529
|
February 17, 2021
|
|
Union Queries with totals, data from same table
|
|
5
|
288
|
February 17, 2021
|
|
Field Associated with Subquery
|
|
3
|
197
|
February 17, 2021
|
|
Are these joins the same?
|
|
2
|
262
|
February 17, 2021
|
|
Return row with latest timestamp from groupings of revisions
|
|
5
|
769
|
February 17, 2021
|
|
Is it possible to specify the order in a STRING_AGG()?
|
|
2
|
657
|
February 15, 2021
|
|
Is there a data health table in SQL similar to Python?
|
|
5
|
294
|
February 15, 2021
|
|
Permissions in SQL
|
|
5
|
615
|
February 15, 2021
|
|
Is it possible to achieve this referencing?
|
|
13
|
311
|
February 14, 2021
|
|
Split data from one row into separate rows and add two columns
|
|
7
|
238
|
February 14, 2021
|
|
What is the difference between ON C1=C2 AND C3=C4 and ON (C1=C2 AND C3=C4)?
|
|
10
|
1593
|
February 14, 2021
|
|
Aggregate function usage as filter
|
|
5
|
235
|
February 13, 2021
|
|
View of two linked tables, one to many relationship
|
|
6
|
300
|
February 12, 2021
|
|
Is it possible to return all dates in 2020-01-01 format?
|
|
4
|
238
|
February 12, 2021
|
|
Do these WHERE statements have any difference?
|
|
1
|
239
|
February 11, 2021
|
|
Do I need to table-reference columns in nested SELECT?
|
|
7
|
433
|
February 11, 2021
|
|
How to store a list in SQL?
|
|
6
|
1380
|
February 11, 2021
|
|
What is the way to store tables/arrays in variables?
|
|
5
|
310
|
February 11, 2021
|