SELECT * FROM EMP WHERE TO_CHAR(HIREDATE,'FMDAY') = 'MONDA

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

Question Posted / ajit nayak

Answer Posted / ajit nayak

SELECT *
FROM EMP
WHERE TO_CHAR(HIREDATE,'FMDAY') = 'MONDAY';

Is This Answer Correct ?

6 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the difference between mdf and ndf files?

1063

how to calculate expressions with sql statements? : Sql dba

985

What is sql key?

923

what are the limitations of identity column? : Transact sql

1052

What is indexing in sql and its types?

1007

How do you modify a trigger?

876

What are the two parts of design view?

975

What is write ahead logging in sql server?

989

What operators deal with null?

1031

What are packages in pl sql and also explain its advantages?

961

Why we use joins in sql?

926

What if we write return in procedure?

1336

What is trigger explain it?

966

What is left inner join in sql?

986

What is where clause in sql?

984