I have a database table with two columns updated_at and children_updated_at and I would like to show the latest modified records first based on the SQL function GREATEST(updated_at, children_updated_at). The SQL query I'd like to generate is: select * from…
I use WAMP on my dev machine running MariaDB. On the server I use MySQL. The main page is a list of events sorted by a metavalue: event_date. Here's the query as generated by Wordpress SELECT wp_posts.ID, wp_postmeta.meta_value FROM wp_posts…
Select CONCAT ( Name, '(' , LEFT(occupation,1) , ')' ) FROM occupations UNION Select CONCAT ('There are a total of ', Count(Occupation) ,' ', occupation, 's' ) as line FROM occupations Group by occupation ORDER by line Why can I…
Apparently, sorting is somehow applied incorrectly in mysql 8 (checked on 8.0.33 to 8.0.35) when query has ORDER BY + GROUP BY + GROUP_CONCAT() + COUNT(*) OVER() window function. See test case below (NOTE that it's synthetic and oversimplified for…
I have a simple table, but want to add a code so i can put a special result in a chosen position. SELECT * FROM table ORDER BY rating DESC LIMIT 10; I also have a column called position. If…
Hi I have these set $numbser (varchar) CA 0000002 CA 0000001 CA 10000000 CA 1111111 CA 2222222 CA 20000000 CB 0000001 CB 0000002 CB 1111111 When I use order by numbser, I get these. SELECT * FROM stock ORDER BY…
How to sort text in PostgreSQL in Latvian alphabetic order, so any letter without accent always comes before the letter with accent? For example this select * from ( select 'bā' as name union select 'āa' union select 'ac' union…
I have a table with some columns : Id Active timestamp 1 TRUE 23-09-10 2 NULL 23-09-11 3 FALSE 23-09-12 4 TRUE 23-09-15 5 NULL 23-09-16 I want to order my results according to this priority order If boolean is…
I am building a custom e-commerce platform for a music store using a client's existing inventory list in which each item has a unique "System ID" (represented by a MySql table inventory). The problem is several "unique" items in the…
I'm trying to order this results by date in descending order with this query SELECT DISTINCT d.id, to_char(d.creation_date::date, 'dd/mm/yyyy') AS delivered_date FROM delivery_kits_equipment_of_visit d WHERE d.deleted IS NOT TRUE AND d.deleted = 'FALSE' ORDER BY to_char(d.creation_date::date, 'dd/mm/yyyy') DESC LIMIT 10…