Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.php > #10391
| Path | csiph.com!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!feeder4.news.weretis.net!rt.uk.eu.org!newsfeed.xs4all.nl!newsfeed1.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail |
|---|---|
| Date | Sun, 04 Aug 2013 19:37:32 +0200 |
| From | Luuk <luuk@invalid.lan> |
| User-Agent | Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20130620 Thunderbird/17.0.7 |
| MIME-Version | 1.0 |
| Newsgroups | comp.lang.php, alt.php |
| Subject | Re: sql order but move some rows bottom |
| References | <1qthmi1tu68bo$.9vs28kns3wda.dlg@40tude.net> <b14vca-jku.ln1@luuk.invalid.lan> <13413lih7j7xy.ntybohdhh9wy.dlg@40tude.net> <frnvca-j63.ln1@luuk.invalid.lan> <19m253q4wpnqg.3aexf4o8h0ae$.dlg@40tude.net> <1l02da-q4u.ln1@luuk.invalid.lan> <cilihgucmwnw.1jmbvfrj3djn8.dlg@40tude.net> |
| In-Reply-To | <cilihgucmwnw.1jmbvfrj3djn8.dlg@40tude.net> |
| Content-Type | text/plain; charset=ISO-8859-1; format=flowed |
| Content-Transfer-Encoding | 7bit |
| Message-ID | <q3g2da-vl1.ln1@luuk.invalid.lan> (permalink) |
| Lines | 18 |
| NNTP-Posting-Host | 2001:980:9089:1:1485:831:d105:93a6 |
| X-Trace | 1375638002 news.xs4all.nl 15952 [2001:980:9089:1:1485:831:d105:93a6]:44432 |
| X-Complaints-To | abuse@xs4all.nl |
| Xref | csiph.com comp.lang.php:10391 |
Cross-posted to 2 groups.
Show key headers only | View raw
On 04-08-2013 17:49, nawfer wrote: >> y before 100: >> ORDER BY >> (CASE WHEN column2 = 100 THEN 2 ELSE 0 END + CASE WHEN column3='Y' THEN >> 1 ELSE 0 END) ASC, column1 ASC, column2 ASC > > small curiosity > the above code respect at a simple order > > ORDER BY column1 ASC, column2 ASC > > > change the performance (example - 5%)or is insignificant the difference? > Sorry, my English is not good enough to understand what you mean ..... Could you rephrase the question?
Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
sql order but move some rows bottom nawfer <novalidsforspam@alt.al> - 2013-08-03 12:44 +0200
Re: sql order but move some rows bottom Luuk <luuk@invalid.lan> - 2013-08-03 12:53 +0200
Re: sql order but move some rows bottom nawfer <novalidsforspam@alt.al> - 2013-08-03 18:10 +0200
Re: sql order but move some rows bottom Luuk <luuk@invalid.lan> - 2013-08-03 18:31 +0200
Re: sql order but move some rows bottom nawfer <novalidsforspam@alt.al> - 2013-08-04 13:50 +0200
Re: sql order but move some rows bottom Luuk <luuk@invalid.lan> - 2013-08-04 15:13 +0200
Re: sql order but move some rows bottom anver <NOSPAMM@NO.SPAMMS> - 2013-08-04 16:42 +0200
Re: sql order but move some rows bottom nawfer <novalidsforspam@alt.al> - 2013-08-04 16:56 +0200
Re: sql order but move some rows bottom Luuk <luuk@invalid.lan> - 2013-08-04 19:36 +0200
Re: sql order but move some rows bottom nawfer <novalidsforspam@alt.al> - 2013-08-04 19:52 +0200
Re: sql order but move some rows bottom nawfer <novalidsforspam@alt.al> - 2013-08-05 14:50 +0200
Re: sql order but move some rows bottom nawfer <novalidsforspam@alt.al> - 2013-08-04 17:49 +0200
Re: sql order but move some rows bottom Luuk <luuk@invalid.lan> - 2013-08-04 19:37 +0200
Re: sql order but move some rows bottom nawfer <novalidsforspam@alt.al> - 2013-08-04 19:53 +0200
Re: sql order but move some rows bottom Luuk <luuk@invalid.lan> - 2013-08-04 20:20 +0200
Re: sql order but move some rows bottom nawfer <novalidsforspam@alt.al> - 2013-08-05 14:57 +0200
csiph-web