I'm trying to get something I thought should be relatively simple (it works in Oracle and MySQL). The PostgreSQL fiddle for the code below is available here - just change the server to check out the others. Very simple test…
I have a MySQL table called names with a column names name. This column has the following values: Beacher Ackley Addison Caldwell Cameron Alcott Carling Beardsley Beldon I want to get, alphabetically sorted, the value of every first letter. Alphabetically…
I need 10 random ids at time. I need to get a new set of random ids every time I ask for a new set, but the new ones must not include any of the ones I already got from…
There are 2 samples. In the first example, it gives faster results when using orderby. (according to phpmyadmin speed report) In the other example, I don't use order by, it gives slower results. (according to phpmyadmin speed report) Isn't it…
I have a problem with the following sorting: SELECT name FROM unnest(ARRAY[ 'MIR1290', 'MIR1291', 'MIR129-1', 'MIR1292', 'MIR129-2', 'MIR1293', 'MIR1294', 'MIR1296', 'MIR1297', 'MIR1298', 'MIR1299' ]) name ORDER BY name; In one server is sorted as follows: "name" "MIR1290" "MIR129-1" "MIR1291" "MIR129-2"…
I have the next query to get the 15 most sold plates in a place: This query is taking 12 seconds to execute over 100,000 rows. I think this execution takes too long, so I am searching a way to…
PLEASE SEE THE LAST EDIT ON THE BOTTOM I have the following query using MySQL in phpMyAdmin: (SELECT id, name, rank1, rank2 FROM rank_list LEFT JOIN names ON names.id = rank_list.name_id WHERE type = "typeA" ORDER BY rank1 LIMIT 50)…