User Ergest Basha

6 votes

Accepted

SQL to handle multiple AND conditions

answered Feb 2, 2022 at 20:52

6 votes

Accepted

Alter command showing syntax error in MySQL 8.0

answered Mar 25 at 17:02

5 votes

Accepted

How do I get the date next week in SQL (Firebird)?

answered Jan 30 at 9:49

5 votes

Accepted

indexing multiple columns in a table in MySQL

answered Jan 30 at 17:00

5 votes

Not getting the concept of COUNT with GROUP BY?

answered Jun 5 at 10:38

5 votes

Accepted

MariaDB - search over multiple rows with same id

answered Feb 13, 2022 at 19:22

5 votes

Accepted

how to find out if I am in azure or not?

answered Jul 25, 2022 at 15:32

5 votes

Why MySQL 5.7 timestamp not null requires default value?

answered Jul 27, 2022 at 7:45

4 votes

Date not being imported from csv in proper format in MySQL

answered Feb 16, 2022 at 16:50

4 votes

Accepted

Generate series 0.01 to 0.99

answered Sep 3, 2021 at 9:22

4 votes

Advantage of "LOAD DATA ... REPLACE INTO TABLE" over "UPDATE table_name SET"

answered Oct 2, 2022 at 17:43

4 votes

Accepted

Missing FROM-clause entry for table in postgres CTE

answered Nov 15, 2022 at 14:08

4 votes

Accepted

Make two columns unique both ways

answered Dec 3, 2022 at 9:02

4 votes

How to limit the amount of values within a postgres table which are updated

answered Jan 4 at 9:00

3 votes

Select all records in which the sum of values are equal to a specific value

answered Dec 23, 2022 at 13:17

3 votes

Accepted

is it possible to manipulate a temporary table with triggers?

answered Nov 18, 2022 at 19:52

3 votes

Accepted

Group BY DESC being ignored after join - Mysql 5

answered Nov 24, 2022 at 14:53

3 votes

Accepted

Select rank of single row

answered Oct 22, 2022 at 11:11

3 votes

Accepted

In Snowflake, how do I CAST CURRENT_TIMESTAMP up to the minute only?

answered May 5 at 13:33

3 votes

Accepted

why the mysql has two root user

answered Sep 27, 2021 at 12:12

3 votes

How to import only a specific database from a .sql file?

answered Dec 4, 2021 at 18:35

3 votes

How to start MySQL after failure?

answered Jan 26, 2022 at 16:58

3 votes

how can I convert this SQL statement with nested IN clauses to a JOIN format

answered Apr 26, 2022 at 11:17

3 votes

SQL join on an edited field

answered Feb 8, 2022 at 16:57

3 votes

CTE get all descendants with parents

answered May 30, 2022 at 10:14

3 votes

Return NULL when distinct values else return value

answered Jun 27, 2022 at 17:57

3 votes

Accepted

Optimize a query multiple tables & Multiple conditions

answered Aug 9, 2022 at 20:48

2 votes

Accepted

How can I change the REFERENCE in a FOREIGN KEY?

answered Sep 15, 2022 at 17:38

2 votes

How to check if WHERE = value does not exist and make it zero by default?

answered Sep 6, 2022 at 8:46

2 votes

Accepted

MySQL root always has access

answered Mar 23, 2022 at 21:49

Stack Exchange Network

158 Answers

SQL to handle multiple AND conditions

Alter command showing syntax error in MySQL 8.0

How do I get the date next week in SQL (Firebird)?

indexing multiple columns in a table in MySQL

Not getting the concept of COUNT with GROUP BY?

MariaDB - search over multiple rows with same id

how to find out if I am in azure or not?

Why MySQL 5.7 timestamp not null requires default value?

Date not being imported from csv in proper format in MySQL

Generate series 0.01 to 0.99

Advantage of "LOAD DATA ... REPLACE INTO TABLE" over "UPDATE table_name SET"

Missing FROM-clause entry for table in postgres CTE

Make two columns unique both ways

How to limit the amount of values within a postgres table which are updated

Select all records in which the sum of values are equal to a specific value

is it possible to manipulate a temporary table with triggers?

Group BY DESC being ignored after join - Mysql 5

Select rank of single row

In Snowflake, how do I CAST CURRENT_TIMESTAMP up to the minute only?

why the mysql has two root user

How to import only a specific database from a .sql file?

How to start MySQL after failure?

how can I convert this SQL statement with nested IN clauses to a JOIN format

SQL join on an edited field

CTE get all descendants with parents

Return NULL when distinct values else return value

Optimize a query multiple tables & Multiple conditions

How can I change the REFERENCE in a FOREIGN KEY?

How to check if WHERE = value does not exist and make it zero by default?

MySQL root always has access