DISPLAY EVEN or ODD NUMBER OF RECORDS
For Even row For Odd row Using Dense_rank() Even row output on tool Retrieve even records from emp table Odd row output on tool Retrieve odd records from…
0 Comments
October 1, 2020
Display top 7 records from emp table
OUTPUT RN EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 1 7369 SMITH CLERK 7902 17-DEC-80 800 null 20 2 7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30 3 7521…
October 1, 2020
SQL Commands
Data Definition Language(DDL) DDL deals with the structure of objects. DDL commands interact with database directly. DDL commands enforce an implement commit before & after statement . Cannot undo (rollback)…
September 26, 2020
What is SQL ?
SQL · SQL stands for Structured Query Language, which is used to communicate with the database. · It requires an environment to implement its features in the form of…
September 21, 2020