How to separate records and ORDER BY


Posted on 16th Feb 2014 07:03 pm by admin

Let say i have 100 records and displayed in one page, then i want to get the records from 50-100 and use ORDER BY to re-order whether DESC or ASC

How can i do the ORDER BY without re-order first 50 records (0-49)...

Did you know?Explore Trending and Topic pages for more stories like this.
I've tried LIMIT 49,50 but it still re-order the first 50 records...

anyone has a clue?
No comments posted yet

Your Answer:

Login to answer
116 Like 8 Dislike
Previous forums Next forums
Other forums

moving mouse to display image coordinates
I have an existing MFC application that shows an image in the main window.
I'd like to be able to

A href problem under php
Hello...

I tried to explain the issue in an earlier post.. but was not clear enough....

comparing tables across databases sql refinement ideas required
Hi all

Via pl/sql I need to ensure that data between tables in different databases match

2 decima places & How to reload my page
Hello There,

How do i put full-stop (.) after second figure from behind? ie if i have 123456

UTL File problem
Hi
I have a file in certain path with the following permissions (The file is a dummy file witho

$get problem
Hi Guys ...

can you please tell me what i am doing wrong here
Code: <?php

PHP5/Zend 2.0 - Resources
PHP5 Snapshots
http://snaps.php.net/

ZEND 2.0 Feature Overview and Design (PDF File

Grabbing Values From an Array for Posting
I have a grid array that I am using with a form that when it hits the currently named test.php it lo

split string
Hi all

i have some names (imploded by comma):
Code: toronto,paris,madrid
Now, i would

Pspell with my own dictionary
Hello!
I've tested two cases using pspell functions.
1)
Code: $dictionary_link = pspell_new

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash