Write a query to find the name of employees those who have
joined on Monday.(based on column hire_date)

Answer Posted / kavitha nedigunta

select ename
from emp
where trim(to_char(Hiredate,'day')) ='monday'

Is This Answer Correct ?    19 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can I tell if sql is running?

600


Which join is like an inner join?

537


How do you clear the screen in sql?

611


What is the advantage of index in sql?

551


when is the use of update_statistics command? : Sql dba

510






What is the difference between instead of trigger and after trigger?

518


What is linq to sql?

567


how many groups of data types? : Sql dba

579


What is relationship? How many types of relationship are there?

599


What are the steps for performance tuning.

851


What is the meaning of disabling a trigger?

655


What packages(if any) has oracle provided for use by developers?

5043


What is sql catalog?

580


Which one is better subquery or joins?

568


Explain what is sql*plus?

674