Questions about sql
Read more about sql
python (12.9k questions)
javascript (9.2k questions)
reactjs (4.7k questions)
java (4.2k questions)
java (4.2k questions)
c# (3.5k questions)
c# (3.5k questions)
html (3.3k questions)
How to connect to a redshift database with Cypress?
I am having issues trying to connect to a redshift database on Cypress, I've followed the instructions from the official cypress-sql-server webpage, please see my configurations files below
--> cyp...
shaveax
Votes: 0
Answers: 0
SQL aggregate function with if condition
I'm wondering if I can perform count function on different status_id with condition when status_id is X then something
This is my current query:
select count(*), status_id
from users
group by status_i...
Mike Ross
Votes: 0
Answers: 2
group by clause creating wrong result
When using aggregate functions you must include all of the other columns selected inside of a group by clause, but doing so the result becomes incorrect. Take this as an example:
SELECT Squadre.Codice...
newbie
Votes: 0
Answers: 1
Get the max date of dates in a column that are > than 6 days prior to another date column
I have data where I want to compare what date was given 6 days or more prior to another date.
Example: the actual date time is 15th Jan 2022, I would like to see what the estimated time was 6 or more ...
T walker
Votes: 0
Answers: 1