SELECT FIRST_NAME,LAST_NAME FROM employees where TRIM(TO_CHAR(TO

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

Question Posted / prasant

Answer Posted / prasant

SELECT FIRST_NAME,LAST_NAME FROM employees
where TRIM(TO_CHAR(TO_DATE(HIRE_DATE),'DAY'))='MONDAY';

if any issue,contact me.

Is This Answer Correct ?

48 Yes

8 No

Please Help Members By Posting Answers For Below Questions

What is the difference between microsoft access and sql server?

1104

How do you update a table in sql?

1037

What is the source code of a program?

1118

Is sql developer case sensitive?

1047

Can we group by two columns in sql?

1045

How to fetch alternate records from a table?

1305

What is %s in sql?

1075

What is the use of desc in sql?

1017

How do you update a value in sql?

1100

What is posting?

1083

What is flag in sql?

1097

When is a declare statement required?

1193

what are the advantages and disadvantages of views in a database? : Sql dba

1072

Explain autonomous transaction.

1218

Is a table valued function object?

1073