Skip to main content

List the emps along with their Exp and Daily Sal is more than Rs.100.


A) select * from emp where (sal/30) >100;
Labels:

Comments

  1. Vamshi Surapaneni20 September 2013 at 05:07

    where is exp

    ReplyDelete
  2. Vamshi Surapaneni20 September 2013 at 05:11

    This comment has been removed by the author.

    ReplyDelete
    Replies
    1. Vamshi Surapaneni20 September 2013 at 05:15

      select empno, ename, sal, sal/30 daily, months_between(sysdate,hiredate) exp from emp where (sal/30) > 100;

      Delete
  3. Vamshi Surapaneni20 September 2013 at 05:14

    select empno, ename, sal, sal/30 daily, months_between(sysdate,hiredate) exp from emp where (sal/30) > 100;

    ReplyDelete
    Replies
    1. Anonymous2 June 2022 at 10:16

      Thank you very much 😊

      Delete
  4. Kunchepu Himaja7 August 2021 at 04:11


    select empno,ename,sal,sal/30 daily_sal,hiredate,(select sysdate from dual) "exp" from emp where sal>100;

    ReplyDelete

Post a Comment

Popular Posts

How to find out Max Salary from each department

You can find maximum salary for each department by grouping all records by DeptId and then using MAX() function to calculate maximum salary in each group or each department. SQL Query: SELECT DeptID, MAX(Salary) FROM Employee  GROUP BY DeptID. This questions become more interesting if Interviewer will ask you to print department name instead of department id, in that case you need to join Employee table with Department using foreign key DeptID, make sure you do LEFT or RIGHT OUTER JOIN to include departments without any employee as well.  Here is the query
Post a Comment
Read more