Featured Post

What is the purpose of the php.ini file?

  The PHP configuration file,   php.ini , is the final and most immediate way to affect PHP's functionality. The php.ini file is read ea...

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


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

6 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

Subscribe to: Post Comments (Atom)

Popular Posts