how to retrieve daily sal from emp table in oracle 10g
Answers were Sorted based on User's Feedback
Answer / anuradha
Select empno,ename,sal, sal/30 "Daily_Sal" From emp;
Is This Answer Correct ? | 4 Yes | 1 No |
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 |
How to create a new user account in oracle?
How many memory layers are in the shared pool?
What is sharded cluster?
Find all employees in Dept “Marketing”.
How to loop through a cursor variable?
IS it possible to built the oracle database without setting the kernal parameters?
3. Display all the client numbers in the ORDER table. Remove duplicates.
When do we use group by clause in a sql query?
What is transaction control statement and how many types of transaction control statement in Oracle?
how do u know the total no of rows in a table?
Explain the use of log option in exp command.
11. Display the client number and name and the client number and name of the person who referred that client.