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 having clause in sql?

950

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1125

What are inbuilt functions in sql?

1030

Is the primary key an index?

1019

How do sql triggers work?

1024

How do I create a sql script?

1085

what tools available for managing mysql server? : Sql dba

1066

What is error ora-12154: tns:could not resolve the connect identifier specified?

1058

What is the difference between instead of trigger and after trigger?

983

What is execution plan in sql?

1024

How do you exit in sql?

1096

how many sql ddl commands are supported by 'mysql'? : Sql dba

1005

How do I send sql query results to excel?

1048

Does varchar need length?

980

How to rename a table?

1001