sql-order-by Archives

MySQL, Programming

IT Nursery

MySQL: Sort GROUP_CONCAT values

In short: Is there any way to sort the values in a GROUP_CONCAT statement? Query: GROUP_CONCAT((SELECT GROUP_CONCAT(parent.name SEPARATOR " » ") FROM test_competence ...

June 2, 2022
0 Comments

Programming, sql

IT Nursery

What is the purpose of Order By 1 in SQL select statement?

I’m reading through some old code at work, and have noticed that there are several views with an order by 1 clause. What ...

June 2, 2022
0 Comments

MySQL, Programming

IT Nursery

GROUP_CONCAT ORDER BY

I’ve a table like: +-----------+-------+------------+ | client_id | views | percentage | +-----------+-------+------------+ | 1 | 6 | 20 | | 1 | ...

May 31, 2022
0 Comments

MySQL, Programming

IT Nursery

Why does MYSQL higher LIMIT offset slow the query down?

Scenario in short: A table with more than 16 million records...

May 30, 2022
0 Comments

Programming, sql

IT Nursery

ORDER BY the IN value list

I have a simple SQL query in PostgreSQL 8.3 that grabs a bunch of comments. I provide a sorted list of values to ...

May 28, 2022
0 Comments

MySQL, Programming

IT Nursery

how to customize `show processlist` in mysql?

I want to order by Time,but seems no way to do that ? mysql> show processlist; +--------+-------------+--------------------+------+---------+--------+----------------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host ...

May 28, 2022
0 Comments

How to order by with union in SQL?

Is it possible to order when the data is come from many select and union it together? Such as Select id,name,age From Student ...

May 22, 2022
0 Comments

Laravel Eloquent: Ordering results of all()

I’m stuck on a simple task. I just need to order results coming from this call $results = Project::all(); Where Project is a ...

May 19, 2022
0 Comments

PostgreSQL DISTINCT ON with different ORDER BY

I want to run this query: SELECT DISTINCT ON (address_id) purchases.address_id, purchases.* FROM purchases WHERE purchases.product_id = 1 ORDER BY purchases.purchased_at DESC But ...

May 19, 2022
0 Comments