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
- 10705 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 are the different types of joins in sql?
Can you selectively load only those records that you need? : aql loader
What are % type and % rowtype?
What are sql ddl commands?
Which join is like inner join?
What is #table in sql?
What is the difference between function, procedure and package in pl/sql?
what is 'trigger' in sql? : Sql dba
What is the maximum size of sqlite database?
how to create a new view in mysql? : Sql dba
what tools available for managing mysql server? : Sql dba
Explain the uses of control file.
differentiate between float and double. : Sql dba
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
What is trigger and how to use it in sql?
