SELECT ENAME FROM EMP WHERE 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 / mahendar reddy

15 Answers
41540 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / mahendar reddy

SELECT ENAME FROM EMP WHERE TO_CHAR(TO_DATE(HIREDATE),'D')='2';

IT fetch the employee name who joined on monday
Here
1=sunday
2=monday
--
---
--
--
--etc

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is rownum in sql?

1093

What are stored procedures in mysql?

1074

What is pl sql commands?

1097

is mysql query is case sensitive? : Sql dba

1164

Why is stored procedure faster than query?

1021

How do rank () and dense_rank () differ?

1109

What is raid? How does it help storage of databases?

1133

What are the different types of triggers?

1191

How is data stored in sql?

1101

Is sql a backend?

1073

What is function and procedure in pl sql?

1119

how to include comments in sql statements? : Sql dba

999

How is data stored on a disk?

1082

what is data integrity? : Sql dba

1086

what is 'mysqld'? : Sql dba

1017