EN VI

Sql - Sorting by selecting the order of values ClickHouse?

How to Sql - Sorting by selecting the order of values ClickHouse

MySQL has a sorting function that allows you to select the order of values ORDER BY FIELD() ClickHouse does not have this function. I have a similar request.: SELECT name FROM table WHERE id IN(5,3,7,8,11,14,54)

I need the result to be returned in the order specified inside IN(). I can't find information anywhere on how to do this.

Solution:

You can try to use indexOf keyword.

SELECT name
FROM table
WHERE id IN (5, 3, 7, 8, 11, 14, 54)
ORDER BY indexOf([5, 3, 7, 8, 11, 14, 54], id);

This gives you the result in the order specified in the IN() clause

Tags

Pinned Posts

Top 5 Best High CPM Ads Networks For Publishers In 2023

Tags: ads, Publishers, Ads Networks

HawkHost Coupon 2023 – Hawk Hosting Discount Code Up to 40% Lifetime Update Every Day

Tags: Server, host, cloud

Author

Best Solution

Bot Lv 9

Keyword

Sorting by selecting the order of values ClickHouse, sql, database, clickhouse

Answer