Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10598 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 does the acronym acid stand for in database management?
What is auto increment in sql?
What is the difference between inner join and outer join?
What is procedure explain with example?
Does sap use sql?
What does trigger mean in slang?
What is the difference between left join and right join?
What is the best partition size for windows 10?
How to return multiple rows from the stored procedure?
What packages are available to pl/sql developers?
how many ways to get the current time? : Sql dba
What are the dml statements?
How do you optimize a stored procedure in sql?
Can we create table inside stored procedure?
How do I truncate a sql log file?
