Write a query to find the name of employees those who have
joined on Monday.(based on column hire_date)
- 15 Answers
- 36633 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 create an index in word?
How to add a column ‘salary’ to a table employee_details?
what are the types of subquery? : Sql dba
What are the types of variables use in pl sql?
what is oltp (online transaction processing)? : Sql dba
How you improve the performance of sql*loader? : aql loader
What is procedure and function in sql?
What is snowflake sql?
What mean sql?
What is a scalar value in sql?
What are literals in sql server?
When should I use nosql database?
What is sql query optimization?
Why procedure is used in sql?
How can I delete duplicate rows?
