Random order by but first 3

From: Arup Rakshit <aruprakshit(at)rocketmail(dot)com>
To: Pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Random order by but first 3
Date: 2015-06-11 16:35:16
Message-ID: 36431696.812292.1434040516904.JavaMail.yahoo@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Suppose I have a column t1 for a table. Now t1 holds some numerice value for each row. Say R1 to R5 records has values for the column t1 as :

t1(2,5,8,10,32)

I want the result to be printed as (10, 32, 8, 2, 5) means - Big, Biggest, small , <then any random order>
Regards,
Arup Rakshit

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2015-06-11 16:55:57 Re: SET LOCAL synchronous_commit TO OFF
Previous Message Robert DiFalco 2015-06-11 16:34:44 SET LOCAL synchronous_commit TO OFF