Dayananda Sagar Computer Science Department

[...] the first 4 char of employee name and last 4 char of job for all employees. 25. Show the employee details in the following format. “Mr. smith is a clerk with 2000 sal in dept 10″. 26. [...]

[...] emp table in the descending order of department number. 8. Display different job types. 9. Display employees whose salary is between 1000 and 2000. 10. Display employees who are working in dept 10 and [...]

[...] employee order by last_name, department_id desc SQL > Select department_id, count(*), from employee group by department_id SQL > Select department_id, count(*), max(salary), min(salary), avg( [...]

[...] order and then on department_id in descending order.   Group By & Having Clause: How many employees who are working in different departments wise in the organization List out the department [...]

[...] programmers are there? What are the languages known by the male programmers? What is the average salary? How many people draw 5000 to 7500? Display the details of those who don’t know C, C++ or [...]

[...] out the employees whose annual salary does not exceed 50,000. 24. Show the first 4 char of employee name and last 4 char of job for all employees. 25. Show the employee details in the following [...]

[...] WHERE CCOST BETWEEN 10000 AND 15000; SELECT AVG(CCOST) FROM STUDIES; SELECT * FROM PROGRAMMER WHERE PROF1 = ‘C’ OR PROF2 = ‘C’; SELECT * FROM PROGRAMMER WHERE PROF1 IN (&# [...]

[...] id” from employee; SQL > Select last_name, salary*12 “annual salary” from employee SQL > Select * from employee where last_name=’SMITH’; SQL > Select * from employee [...]

[...] in DFD e) entities in ERD should correspond to an existing entity/store in DFD     SQL SQL 1.      Which is the subset of SQL commands used to manipulate Oracle Database structures, [...]