how to retrieve daily sal from emp table in oracle 10g

Question Posted / g.venkatmahesh17

2 Answers
5709 Views
Infosys, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to retrieve daily sal from emp table in oracle 10g..

Answer / anuradha

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

Is This Answer Correct ?

4 Yes

1 No

how to retrieve daily sal from emp table in oracle 10g..

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

Is This Answer Correct ?

2 Yes

0 No

Post New Answer

More Oracle General Interview Questions

5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.

3 Answers Wipro,

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

0 Answers GTL,

What is the difference between SQL and SQL Server?

2 Answers CTS, TCS,

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

0 Answers

What is Hash Cluster ?

2 Answers

Does oracle charge for java?

0 Answers

a query to select maxmun 3 salaries of employee table