Select* from emp where to_char(hiredate,'dy')='mon';

Write a query to find the employees from EMP table those who
have joined in Monday. (there is a column as hiredate which is
a date column i.e values are like 03-DEC-81)

Question Posted / siva

5 Answers
10504 Views
I also Faced
E-Mail Answers

Answer Posted / siva

Select* from emp where to_char(hiredate,'dy')='mon';

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do sql triggers work?

1002

Explain autonomous transaction.

1121

how to return query output in html format? : Sql dba

1037

what is single byte over head in oracle..?

2366

Why indexing is needed?

956

what are the t string functions available in tsql? : Transact sql

967

What operating systems are supported by oracle sql developer?

922

What does trigger mean in slang?

1023

Why coalesce is used in sql?

956

What are inbuilt functions in sql?

1013

What is nvl?

1033

What is identity column in sql server?

1008

What are reports usually used for?

986

What is the use of & in pl sql?

1008

Can I join the same table twice?

1010