fishScript.com Script con annotazioni in italiano e inglese

PostgreSQL

Home >PostgreSQL > Ordering by highest or lowest value of multiple columns

Functions such as greatest and least to define an ordering criteria based on the highest or lowest values within multiple columns.

select tnx_id, tnx_time_verified,tnx_time_request,tnx_time_completed from tnx order by greatest(tnx_time_verified,tnx_time_request,tnx_time_completed);

   	tnx_id|  tnx_time_verified      |   tnx_time_request      |tnx_time_completed 
----------+-------------------------+-------------------------+-------------
212024276 | 2017-01-01 00:00:20.245 | 2017-01-01 00:00:20.861 | 
212024278 | 2017-01-01 00:00:20.534 | 2017-01-01 00:00:21.094 | 
212024280 | 2017-01-01 00:01:23.597 | 2017-01-01 00:01:24.397 | 
212024282 | 2017-01-01 00:01:29.156 | 2017-01-01 00:01:30.06  | 
212024284 | 2017-01-01 00:02:12.087 | 2017-01-01 00:02:13.035 | 
212024286 | 2017-01-01 00:02:12.463 | 2017-01-01 00:02:13.76  | 
212024290 | 2017-01-01 00:02:12.499 | 2017-01-01 00:02:13.768 | 
212024288 | 2017-01-01 00:02:12.452 | 2017-01-01 00:02:13.772 | 
210243021 | 2017-01-01 00:02:12.517 | 2017-01-01 00:02:13.796 | 
212024310 | 2017-01-01 00:02:12.508 | 2017-01-01 00:02:13.82  |

(...)

Warning: include(ads/text468x15.html): failed to open stream: No such file or directory in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131

Warning: include(): Failed opening 'ads/text468x15.html' for inclusion (include_path='.;C:\php\pear') in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131

Tutorial

PostgreSQL determine database uptime [PostgreSQL]

Postgres check database is Master or Replica ways to check database replication role [PostgreSQL]

Ordering by highest or lowest value of multiple columns PostgreSQL functions in order by clause [PostgreSQL]

Posgresql how disable and renable foreign constraints forcing data into a table ignoring foreign keys (or trigger) [PostgreSQL]
Comandi

date and timestamp simple Using date and timestamp [PostgreSQL]

Add time to a date date function operation [PostgreSQL]

How set a default schema working away in your postgreSQL session [PostgreSQL]

postgres tip: how re-execute a query every n second a nice postgres shell command [PostgreSQL]

Grouping data by the week example date_trunc function, trimming days by the week [PostgreSQL]

How get PosgreSQL table size pg_total_relation_size function [PostgreSQL]

PostgreSQL determine database size pg_database_size function returns database size [PostgreSQL]

PostgreSQL enable autostart at reboot on Centos / Redhat Configure autostart after reboot [PostgreSQL]

Argomenti

PostgreSQL

Cerca