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
10683 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

What is a subquery in sql?

1046

How does left join work in sql?

1008

Explain what is table in a database?

1065

What is a common use of group by in sql?

1051

What are the two types of exceptions in pl/sql?

1052

What is clause?

1158

Explain how to use transactions efficiently : transact sql

986

How do you drop a trigger?

997

What is benefit of creating memory optimized table?

974

What is the example of procedure?

930

Explain the savepoint statement.

1102

Can we use loop in sql?

972

How many commands are there in sql?

1036

What is cursor in pl sql?

1120

How does cross join work in sql?

1022