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

What is an escape character in sql?

1071

What are the advantages of sql?

1099

What is the difference between row level and statement level trigger?

1071

Is a foreign key always unique?

982

What is a memo field?

1015

How does index help in query performance?

1087

Explain normalization and what are the advantages of it?

998

Explain aggregate functions are available there in sql?

1049

Is the primary key an index?

1078

What is Collation Sensitivity ? What are the various type ?

1001

What is clustered index sql?

1030

Can we debug stored procedure?

1064

What is sql character function?

1149

How is data stored on a disk?

1082

What is a file delimiter?

1162