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
- 9497 Views
- I also Faced
- E-Mail Answers
Answer Posted / jprakash025
SQL> select ename,hiredate from emp
2 where
3 to_char(hiredate,'day') like '%sunday%';
ENAME HIREDATE
---------- ---------
WARD 22-FEB-81
SCOTT 19-APR-87
i dont hv monday data, thats y i m using sunday
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
What is the process of debugging?
What is exit statement?
What is a natural join?
How to use distinct and count in sql query? Explain
What is a stored procedure in sql with example?
What is a constraint?
What is cte sql?
How to Declare Fixed Length String Value In PL SQL
what are integrity rules?
How to avoid duplicate records in a query?
Is there a 64 bit version of ssms?
Is merge a dml statement?
what is index? : Sql dba
How many primary keys can a table have?
What is the syntax to add a record to a table?
