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

Undefined offset
The following script checks to see if the user answer matches the correct answer.

Form Fiel

Regarding accessing SQL query issued by any user in Oracle 10g
Hi all,
i want to know the queries issued by various users accessing a database...

ORA-00932: inconsistent datatypes: expected - got CLOB
SO : windows xp
database : XE

there is a table (transito) with two fields of clob

Having a problem get the selected item from a drop down menu
I have been looking at this for days now.

I have a drop down menu that get it's values from a

How do I replace any number of character occurences with one occurrence?
How do I replace any number of character occurences with one occurrence?

Let's say I have:

Day of week
I am using PHP version 5.0.5
I have a varaible ($DATE (date format yyyy-mm-dd)) that is being inc

Consuming MII WebService in Java WebDynpro
Hello,

We are facing a strange situation...

We define a transaction in MII to

Revoking alter any table from a schema
Hi All,

i am working in Oracle 10g.
my requirement is to revoke all kind of DDL oper

Changing files over
Just thought I'd start with the new forums looking really nice .

Ok basically I've made this

extending tidy
I have problem with type-hinting and extending tidy. This code creates error:
Code: class cMyTidy