Question 3: Write SQL queries for the followingBelow, EMP table is given only for reference purpose.EMPNO ENAMЕJOBMGR HIREDATESALCOMMDEPTNO79 02 17-DEC-807369 SMITH7499 ALLEN7521 WARDCLERKSALESMANSALESMAN8001600125029752030307698 20-FEB-817698 22-FEB-813005007566 JONES7654 MARTINMANAGER839 02-APR-8120SALESMAN7698 28-SEP-8112501400307839 01-MAY-817839 09-JUN-817698 BLAKEMANAGER2850307782 CLARKMANAGER2450107788 SCOTT7839 KING7844 TURNER7876 ADAMS20103020ANALYST7566 19-APR-873000PRESIDENT17-NOU-8150001500SALESMAN7698 08-SEP-817788 23-MAY-877698 03-DEC-81110095030001300CLERK7900 JAMESCLERK307902 FORDANALYST7566 03-DEC-817782 23-JAN-82207934 MILLERCLERK10(i) mgr=null, ename=3rd character is N, not known anything else(ii) Give single example with sql queries for each of the following single-row functionCONCAT, INSTR, RPAD, TRIM?(iii) Write an sql query for:SAL not greater than 3000 and JOB has third character "A" in the string and hacommission.(iv) Display employee record before 20-APR-1985.(v) Display only names and salaries of those employees whose salary is between 122000.

SQL has a large number of character functions.Manipulative Character Functions CONCAT, LENGTH,…

(i) mgr=null, ename=3rd character is N, not known anything else (ii) Give single example with sql queries for each of the following single-row functic CONCAT, INSTR, RPAD, TRIM? (iii) Write an sql query for: SAL not greater than 3000 and JOB has third character “A" in the string and h commission. (iv) Display employee record before 20-APR-1985. (v) Display only names and salaries of those employees whose salary is between 2000.

(i) mgr=null, ename=3rd character is N, not known anything else (ii) Give single example with sql queries for each of the following single-row functic CONCAT, INSTR, RPAD, TRIM? (iii) Write an sql query for: SAL not greater than 3000 and JOB has third character “A" in the string and h commission. (iv) Display employee record before 20-APR-1985. (v) Display only names and salaries of those employees whose salary is between 2000.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks