query to sort rowwise in sql

Question

i have a table with say 2 columns of varchar type. i want to query to sort them rowwise in SQLlite.

eg: Table

COLUMN1  COLUMN2
book     apple
lemon    mango
google   amazon

the query should return me this:

apple    book
lemon    mango
amazon   google

Community · Accepted Answer · 2017-05-23 12:18:43Z

3

In SQLite, you can do this using the MIN and MAX functions, as detailed here

SELECT MIN(column1, column2), MAX(column1, column2) FROM mytable

You originally didn't specify the DB type, so I wrote this for MySQL. The logic applies to others as well, though the functions may differ.

SELECT LEAST (column1, column2), GREATEST(column1, column2) FROM mytable

CommunityBot

11 silver badge

answered Nov 28, 2012 at 13:27

ppeterka

20.8k6 gold badges67 silver badges80 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Updated my answer for SQLite. And next time please tag your question with the DB you're using to get better specialised help and quicker...