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
- 8811 Views
- I also Faced
- E-Mail Answers
Answer Posted / pramod
select *
from tbl_employees
where DATENAME(DW,hiredate)='Monday' order by hiredate
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the advantages and disadvantages of stored procedure?
What is sql data?
What is normalization in a database?
What is a Mapplet?
Is sqlite free?
Explain spool.
What is cartesian join in sql?
List the various privileges that a user can grant to another user?
Why do we use view in sql?
What is right join in sql?
What is the difference between rollback and rollback to statements?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
What is constant in pl sql?
What is sql query limit?
Is join an inner join?
