PostgreSQL ORDER BY 列位置(而不是列名) [英] PostgreSQL ORDER BY column position (and not by column name)

问题描述

基本上，我不想:

SELECT firstname, lastname FROM person ORDER BY lastname;

而是:

SELECT firstname, lastname FROM person ORDER BY ;

我可以创建一个映射，但我想知道是否有本地技巧可以做到这一点.

I could create a mapping but I was wondering if there is a native trick to do it.

推荐答案

SELECT firstname, lastname 
FROM person 
ORDER BY 2;  --2nd column

这篇关于PostgreSQL ORDER BY 列位置(而不是列名)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！