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
- 10679 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 minus?
What are dml commands?
How to select all records from the table?
When to use inner join and left join?
What are instead of triggers?
What is dml statement?
how is myisam table stored? : Sql dba
When do we use triggers?
explain the delete statements in sql
How do you rename a table in sql?
How to combine two stored procedures in sql?
Can we update views in sql?
What is sql rowcount?
What is database white box testing and black box testing?
Describe different types of general function used in sql?
