Tag Archives: order by

Order by and Limiting Rows in Postgres and Oracle.

Posted on April 12, 2020 by Deepak Mahto

It seems to be Trivial on how to Limit Rows processed and also Adhere to Order by in Traditional RDBMS.But all Database Engine has it own mechanism to Implement it. Let’s try to Explore Traditional approach in Both Oracle and … Continue reading →

Rate this:

Posted in Oracle Internal, Oracle to, Oracle to PG migration | Tagged , , , , | Leave a comment

#SQLSERVERLearning : Order By Learning.

Posted on March 3, 2017 by Deepak Mahto

Most of folks feel , both(Oracle-SQLServer) are traditional RDBMS database and should or need to work some what “SIMILAR”. But, But when we actually start working on core with queries, development and tuning.We identified a lot of difference between any … Continue reading →

Rate this:

Posted in SQL Server Learning | Tagged , , , , , | 1 Comment

Playing with ORDER BY clause in oracle.

Posted on January 1, 2015 by Deepak Mahto

Most of us must be aware of “ORDER BY” clause and its importance to present data in a specific order (Ascending or Descending). Order by clause is an optional Component of SELECT Query. Oracle Say “Use the ORDER BY clause … Continue reading →

Rate this:

Posted in Oracle Internal | Tagged , , , , , , , | 1 Comment