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)...

I've tried LIMIT 49,50 but it still re-order the first 50 records...

anyone has a clue?

Your Answer:

Login to answer

Other forums

Matchcode in ALV change header column
Hello everyone,

I am working in an SAP system that is currently in upgrade and conversion

help with Get_
ok some how this is not working i am not sure what i am doing wrong here but what this does is when

Help With editting and deleting form
Hallo !!

So look at this image :

http://img194.imageshack.us/img194/8272/snapshot5f.pn

Session variable help
I'm having a very troubling issue. Maybe I'm just looking over something but I have looked at the co

Working with Global Variables
hi, I'm not really sure why the following code is returning a "Call to a member function getBan

Displaying values from a SQL count...
Hi,
Easy enough question i just forget the exact method ..
I have ...

Code: //count win

close site for maintenance
i get a tutorial, saying the following code can put our site offline, and only the developer can vie

Security Exception on pages using AJAX
I am getting the exception: attempted to perform an operation not allowed by the security policy on

How can I uploading Transactional Data from Legacy to New SAP system
Hell Gurus,

I am overwhelmed with questions on how to migrate huge volume of Sales Orders

Date/Time and Checkbox
Hi Everyone,

I am trying to figure out how to insert the current date and tim