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

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

Question Posted / kavitha nedigunta

Answer Posted / kavitha nedigunta

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

Is This Answer Correct ?

19 Yes

5 No

Please Help Members By Posting Answers For Below Questions

How does postgresql compare to oracle/db2/ms sql server/informix?

1018

How to display Row Number with Records in Oracle SQL Plus?

1027

Explain the purpose of %type and %rowtype data types with the example?

974

Are sql database names case sensitive?

981

What can I use instead of union in sql?

949

Why use truncate instead of delete?

992

What is the source code of a program?

1047

Explain how can you save or place your msg in a table?

1017

how to rename an existing column in a table? : Sql dba

1002

How does sql*loader handles newline characters in a record? : aql loader

1026

What is schema in sql?

929

What is view explain with example?

919

How delete all records from table in sql?

961

how many columns can be used for creating index? : Sql dba

932

explain the difference between delete , truncate and drop commands? : Sql dba

1074