Category Archives: sql

Display values ordering by names that are greater than others in sql query

Posted on July 29, 2010 by Alessandro Orsi

If you have a table with some rows, say: SELECT EMPNO, JOB, SAL FROM EMP; EMPNO     JOB         SAL ———- ———-    ——— 7369   CLERK            10000 7566   MANAGER   … Continue reading →

Posted in database, sql | Comments Off

Sort null value in sql query

Posted on July 29, 2010 by Alessandro Orsi

If you have a table with some rows, say: SELECT EMPNO, JOB, SAL FROM EMP; EMPNO     JOB         SAL ———- ———-    ——— 7369   CLERK            10000 7566   MANAGER … Continue reading →

Posted in database, sql | Comments Off