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

Explain unique key in sql.

942

What is the current version of postgresql?

1005

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1032

What are different categories of sql commands?

1067

how does a local variable is defined using t-sql? : Transact sql

947

what is log shipping? : Sql dba

1055

What is the reports view in oracle sql developer?

924

What are the different types of functions in sql?

996

What is sql basics?

991

What is materialized view. What are different methods of refresh?

1330

What is sqlca in powerbuilder?

953

What is a string data type in sql?

957

what are properties of a transaction? : Sql dba

1017

What are triggers and its types?

995

Can ddl statements be used in pl/sql?

1067