select * from (select emp.*,to_char(to

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

Question Posted / arun kumar reddy

Answer Posted / arun kumar reddy

select * from
(select emp.*,to_char(to_date(hiredate),'day') as join_day from emp)
where join_day like'mo%';

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How can we find duplicate records in a table?

887

What is the difference between joins?

974

What is the most common sql injection tool?

991

What is full join?

893

What is crud sql?

919

What is a left inner join?

942

What is form and report?

925

What has stored procedures in sql?

991

how to include character strings in sql statements? : Sql dba

999

How to order siblings in oracle hierarchy queries?

979

Why triggers are used?

936

What is a recursive join sql?

1023

What is difference between pl and sql?

990

What is full form of rtm?

951

What is join view in sql?

893