'Empno ename job' presentation slideshows

Data Retrieval

Data Retrieval. DEPT. DEPTNO DNAME LOC --------- -------------- ---------- 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON. SALGRADE. GRADE LOSAL HISAL

524 views • 43 slides

Restricting and Sorting Data

496 views • 42 slides

Restricting and Sorting Data

Restricting and Sorting Data. Objectives. After completing this lesson, you should be able to do the following: Limit the rows retrieved by a query Sort the rows retrieved by a query. EMP. EMPNO ENAME JOB ... DEPTNO 7839 KING PRESIDENT 10 7698 BLAKE MANAGER 30

370 views • 28 slides

Restricting and Sorting Data

Restricting and Sorting Data. Objectives. After completing this lesson, you should be able to do the following: Limit the rows retrieved by a query Sort the rows retrieved by a query. EMP. EMPNO ENAME JOB ... DEPTNO 7839 KING PRESIDENT 10 7698 BLAKE MANAGER 30

343 views • 27 slides

Restricting and Sorting Data

Restricting and Sorting Data. Objectives. After completing this lesson, you should be able to do the following: Limit the rows retrieved by a query Sort the rows retrieved by a query Group the rows reporting on summary type data. EMP. EMPNO ENAME JOB ... DEPTNO

377 views • 26 slides