Answer / anuradha

Select empno,ename,sal, sal/30 "Daily_Sal" From emp;

Answer / shailesh

I think what Anuradha has suggested is fine but it may not
produce accurate results. I think following query should
return reliable results based on number of days present in
month.

select trunc(salary/ to_number(extract (day from last_day
(sysdate))),2) as daily_sal,salary from employees

You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.

3 Answers   Amazon, HCL,

---

Explain the use of record option in exp command.

0 Answers  

---

What is logical backup in oracle?

0 Answers  

---

Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?

6 Answers   IBM,

---

Is primary key indexed by default in oracle?

0 Answers  

---

Compare and contrast between sql and sql server and explain its various functions?

0 Answers  

---

What is a oracle database?

0 Answers  

---

Name the various constraints used in oracle?

0 Answers  

---

What are the differences between a sys and system user and what are the extra privileges available to the sys user?

1 Answers   Wipro,

---

how to make an oracle object

0 Answers  

---

how to we delete a row using varray

3 Answers   CTC,

---

Explain the use of control file?

0 Answers  

---