Answer to Question #235318 in Databases | SQL | Oracle | MS Access for Tarurendra Kushwah

Question

create table emp with attributes (eid number,ename varchar2(10),age number,salary number);

 

a. Count number of employee names from employee table.

b. Display the Sum of age employee table.

c. Find grouped salaries of employees (group by clause).

d. Find salaries of employee in Ascending Order (order by clause).

e. Find salaries of employee in Descending Order.

Answer 1

create table emp (eid number,ename varchar2(10),age number,salary number);

a) SELECT count(ename) FROM emp;
b) SELECT sum(age) FROM emp;
c) SELECT salary FROM emp GROUP BY salary;
d) SELECT salary FROM emp GROUP BY salary;
e) SELECT salary FROM emp ORDER BY salary DESC