Write a query to find the name of employees those who have
joined on Monday.(based on column hire_date)
- 15 Answers
- 38788 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / ajit nayak
SELECT *
FROM EMP
WHERE TO_CHAR(HIREDATE,'FMDAY') = 'MONDAY';
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
what is commit? : Sql dba
Which is better join or subquery?
What is a temporal data type?
How do you use a while loop in pl sql?
What is auto increment in sql?
What is right join sql?
What is a native sql query?
What is pivot table in sql?
What is time based sql injection?
What can you do with pl sql?
What is sql mysql pl sql oracle?
Does truncate table reset auto increment?
What is sqlite used for?
what's the difference between a primary key and a unique key? : Sql dba
how to convert dates to character strings? : Sql dba
