Write a query to find the name of employees those who have
joined on Monday.(based on column hire_date)
- 15 Answers
- 38750 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
How do I view output in sql developer?
What is identity column in sql server?
What are the advantages of sql? Explain
Which constraints we can use while creating database in sql?
what does the t-sql command ident_incr does? : Transact sql
what is clause? : Sql dba
What is sqlexception in java?
How long does it take to learn pl sql?
what is myisam? : Sql dba
What are crud methods?
What is server name sql?
What is null in pl/sql?
How show all rows in sql?
How many rows can sqlite handle?
Is sql dba a good career? : SQL DBA
