SELECT * FROM EMP where TRIM(TO_CHAR(TRUNC(HIREDATE),'DAY'))=�

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

Question Posted / kiran kumar

Answer Posted / kiran kumar

SELECT * FROM EMP
where TRIM(TO_CHAR(TRUNC(HIREDATE),'DAY'))='SUNDAY'

Is This Answer Correct ?

23 Yes

7 No

Please Help Members By Posting Answers For Below Questions

How to run pl/sql statements in sql*plus?

1143

Can we create view in stored procedure?

1026

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

1017

How can you select unique records from a table?

1146

what are numeric data types? : Sql dba

1111

How do I know if I have sql express or standard?

1062

What are the types pl/sql code blocks?

1195

What is the main difference between sql and pl/sql?

1148

How insert into statements in sql?

1119

What is sql analyzer?

1059

what is online transaction processing (oltp)? : Sql dba

1038

What is dense_rank?

989

what does myisamchk do? : Sql dba

1079

Explain correlated query work?

1100

Which is better join or subquery?

1187