|
Cannot use an aggregate or a subquery in an expression
|
|
3
|
323
|
February 21, 2021
|
|
Calculate days ahead for a date to know expiring password date
|
|
1
|
240
|
February 19, 2021
|
|
Need help with insert/update statement(Appeon Powerbuilder)
|
|
1
|
544
|
February 19, 2021
|
|
Is there a command to drop all temp tables when re-running the query?
|
|
4
|
4960
|
February 19, 2021
|
|
How can I store and reuse (1,2,3)?
|
|
20
|
395
|
February 18, 2021
|
|
Is it possible to store part of a query as a variable to reuse?
|
|
6
|
657
|
February 18, 2021
|
|
How to use 'IF' in a query
|
|
4
|
206
|
February 18, 2021
|
|
Is this strategy robust?
|
|
4
|
192
|
February 17, 2021
|
|
How to hide few digits of account number
|
|
3
|
503
|
February 17, 2021
|
|
Union Queries with totals, data from same table
|
|
5
|
271
|
February 17, 2021
|
|
Field Associated with Subquery
|
|
3
|
196
|
February 17, 2021
|
|
Are these joins the same?
|
|
2
|
262
|
February 17, 2021
|
|
Return row with latest timestamp from groupings of revisions
|
|
5
|
727
|
February 17, 2021
|
|
Is it possible to specify the order in a STRING_AGG()?
|
|
2
|
516
|
February 15, 2021
|
|
Is there a data health table in SQL similar to Python?
|
|
5
|
294
|
February 15, 2021
|
|
Permissions in SQL
|
|
5
|
579
|
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
|
224
|
February 14, 2021
|
|
What is the difference between ON C1=C2 AND C3=C4 and ON (C1=C2 AND C3=C4)?
|
|
10
|
1418
|
February 14, 2021
|
|
Aggregate function usage as filter
|
|
5
|
235
|
February 13, 2021
|
|
View of two linked tables, one to many relationship
|
|
6
|
298
|
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
|
388
|
February 11, 2021
|
|
How to store a list in SQL?
|
|
6
|
306
|
February 11, 2021
|
|
What is the way to store tables/arrays in variables?
|
|
5
|
310
|
February 11, 2021
|
|
Selecting row with the most recent timestamp
|
|
3
|
355
|
February 11, 2021
|
|
Optimizing for Ad hoc Workloads - Downside to turning it on?
|
|
2
|
209
|
February 10, 2021
|
|
How can I calculate the MIN using specific criteria?
|
|
22
|
297
|
February 10, 2021
|
|
Multi conditional Where clause
|
|
9
|
273
|
February 10, 2021
|