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
- 9174 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
Why we use joins in sql?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
What is type and rowtype in pl sql?
How do I view a procedure in sql?
Is inner join same as self join?
What are sql commands?
What operating systems are supported by oracle sql developer?
Describe types of sql statements?
What is the use of <> sql?
What can sql server reporting services do?
What are the indexing methods?
differentiate between float and double. : Sql dba
Why commit is not used in triggers?
Are sql database names case sensitive?
give the syntax of grant and revoke commands? : Sql dba
