order by question
От | Gary Stainburn |
---|---|
Тема | order by question |
Дата | |
Msg-id | 200503091241.55881.gary.stainburn@ringways.co.uk обсуждение исходный текст |
Ответы |
Re: order by question
Re: order by question Re: order by question |
Список | pgsql-sql |
Hi folks. I seem to remember somewhere being shown how to bump specific rows to the top of a list; something along the lines of: select c_id as key, c_des as value from customers order by c_id = 7, c_id = 160, value; however, although the statement is accepted the two rows specified are not bumped to the top of the list, but instead appear in their correct position in the order by value part. Is it possible and if so how do I do it? -- Gary Stainburn This email does not contain private or confidential material as it may be snooped on by interested government parties for unknown and undisclosed purposes - Regulation of Investigatory Powers Act, 2000
В списке pgsql-sql по дате отправления: