Write a query to find the employees from EMP table those who
have joined in Monday. (there is a column as hiredate which is
a date column i.e values are like 03-DEC-81)
- 5 Answers
- 9488 Views
- I also Faced
- E-Mail Answers
Answer Posted / l meher
SQL> select ename,hiredate from emp where trim(to_char(trunc(hiredate),'DAY')) = 'MONDAY';
ENAME HIREDATE
---------- ---------
MARTIN 28-SEP-81
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What is assignment operator in pl sql?
What is the sql case statement?
how many ways we can we find the current date using mysql? : Sql dba
Is natural join same as inner join?
Is sql difficult?
How can I get the number of records affected by a stored procedure?
i have some prob lem to tell me about my self in interview first round ...
Explain what is a subquery ?
How do I view a table in sql?
What is sql in oracle?
What is sql exception?
What are sql data types?
How to start oracle sql developer?
How many sql core licenses do I need?
What does a pl/sql package consist of?
