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

How do temporal tables work?

909

What is the difference between functions, procedures, and packages in pl/sql?

974

Explain two easy sql optimizations.

962

In a distributed database system, can we execute two queries simultaneously?

997

Is full outer join same as cross join?

915

what is the difference between delete and truncate statement in sql? : Sql dba

1130

When to use inner join and left join?

906

What is data types in sql?

950

Can we insert data into view?

850

What is scalar function?

1002

What will you get by the cursor attribute sql%rowcount?

974

Does pdo prevent sql injection?

886

If a cursor is open, how can we find in a pl/sql block?

1105

Is mariadb nosql?

993

What is a table in a database?

993