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 in the asc order of Designations of those joined after the second half of 1981.

Answer:

select * from emp where hiredate > (’30-jun-81’) and to_char(hiredate,’YYYY’) = 1981 order by job asc;

select * from emp where hiredate > (’30-jun-81’) and to_char(hiredate,’YYYY’) = 1981 order by job asc;
at
Labels:

2 comments:

  1. Anonymous24 March 2019 at 23:32

    select * from emp where hiredate > ('30-JUN-1981') order by job asc;

    ReplyDelete
  2. Anonymous5 September 2020 at 09:32

    select * from emp where hiredate >= '07-01-1981' order by job asc

    ReplyDelete

Subscribe to: Post Comments (Atom)

Popular Posts