Ergest Basha's user avatar
Ergest Basha's user avatar
Ergest Basha's user avatar
Ergest Basha
  • Member for 2 years, 7 months
  • Last seen this week
6 votes
Accepted

SQL to handle multiple AND conditions

6 votes
Accepted

Alter command showing syntax error in MySQL 8.0

5 votes
Accepted

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

5 votes
Accepted

indexing multiple columns in a table in MySQL

5 votes

Not getting the concept of COUNT with GROUP BY?

5 votes

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

5 votes
Accepted

MariaDB - search over multiple rows with same id

5 votes

Why MySQL 5.7 timestamp not null requires default value?

5 votes
Accepted

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

4 votes

Date not being imported from csv in proper format in MySQL

4 votes
Accepted

Generate series 0.01 to 0.99

4 votes
Accepted

Make two columns unique both ways

4 votes

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

4 votes

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

4 votes
Accepted

Missing FROM-clause entry for table in postgres CTE

3 votes
Accepted

is it possible to manipulate a temporary table with triggers?

3 votes
Accepted

Group BY DESC being ignored after join - Mysql 5

3 votes
Accepted

Select rank of single row

3 votes
Accepted

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

3 votes
Accepted

why the mysql has two root user

3 votes

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

3 votes

How to start MySQL after failure?

3 votes

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

3 votes

SQL join on an edited field

3 votes
Accepted

Optimize a query multiple tables & Multiple conditions

3 votes

CTE get all descendants with parents

3 votes

Return NULL when distinct values else return value

2 votes

Skip views when using mysqldump

2 votes

How to exceed max_execution_time when running a mysqldump?

2 votes
Accepted

Add value from another table by comparing tables columns

1
2 3 4 5 6