user avatar
user avatar
user avatar
Akina
  • Member for 4 years, 3 months
  • Last seen this week
  • Zelenograd, Moscow, Russia
17 votes
Accepted

How to delete duplicate records in MySQL, in a table without IDs?

14 votes
Accepted

How to update Column related to Row Number

12 votes
Accepted

Is possible to reuse a already calculatesd column into a query in MySQL?

11 votes
Accepted

GROUP BY needs ORDER BY NULL to avoid filesort

9 votes
Accepted

PostgreSQL; Update different column on condition using CASE statement

9 votes
Accepted

Sqlite: Finding the next or previous element in a table consisting of integer tuples

7 votes
Accepted

How to UPDATE from JOIN with GROUP BY

6 votes

How to get last and first occurrence of items into separated columns?

6 votes
Accepted

Get percentage of group by

6 votes
Accepted

MySQL set column value if another column's new value is different than current one

6 votes
Accepted

MSSQL: Generate a 8 digit serial/Barcode number from a prefix number

6 votes
Accepted

Results of using a comparison operator in the ORDER BY clause

6 votes
Accepted

Converting multiple rows to one row

5 votes
Accepted

Meaning of "rows between 15 preceding and 15 following"

5 votes
Accepted

Get ids only where one id is null and other isn't

5 votes

remove leading and trailing quotes

5 votes
Accepted

Count Over returns Row_Number based on Order By

5 votes
Accepted

Understanding NOT EXISTS

5 votes
Accepted

MySQL Query Failed: Expression #6 of SELECT list is not in GROUP BY clause and contains non aggregated column fixed bug reappear every restart

5 votes
Accepted

Avoid duplicates on self join

5 votes
Accepted

Disable foreign key checks during import

4 votes
Accepted

MySQL - Delete with IN Clause taking more time

4 votes

SELECT on column value = X but if no rows available then any column value

4 votes
Accepted

MySQL begin end from documentation doesn't work

4 votes
Accepted

Sql Query with In Operator optmization

4 votes
Accepted

Is there a "soft" ORDER BY / GROUP BY?

4 votes
Accepted

How to group multiple ROW as ARRAY

4 votes

Create new table with a sum where row from table 2 matches field in table 1 and aggregate on another field

4 votes
Accepted

What's difference between MySql IN and ANY operator?

4 votes
Accepted

Merge Multiple Selects in one request

1
2 3 4 5
33