Write a query to find the name of employees those who have
joined on Monday.(based on column hire_date)
- 15 Answers
- 36636 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / venkat
Select first_name,Last_name
from employees
where To_date('HIREDATE','D')=2;
1-SUNDAY
2-MONDAY
----
7-SATURDAY
The advantage of the above query even don't know about the
format of day of the week We get the output.
Monday,
MON
MONDAY
ETC
| Is This Answer Correct ? | 6 Yes | 7 No |
Post New Answer View All Answers
how to install mysql? : Sql dba
How exception is different from error?
Why we use stored procedure instead of query?
What is raid? How does it help storage of databases?
What are the different types of constraints?
What is pl sql and why it is used for?
Does view store data in sql?
How many types of primary keys are there?
How do I view a procedure in sql?
What is sequence in sql?
What is compound trigger?
What is procedure function?
How does pl sql work?
what is commit? : Sql dba
Mention what does the hierarchical profiler does?
