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
- 9494 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
Which join is like inner join?
What are the operators used in select statements?
What is rowid in sql?
Can ddl statements be used in pl/sql?
How to convert comma separated string to array in pl/sql?
What are the parts of a basic sql query?
What is schema in sql example?
What is varchar data type in sql?
How do you rename a table in sql?
List the different type of joins?
what are the 'mysql' command line arguments? : Sql dba
How many parts of a pl sql block are optional?
How many types of relationship are there?
What is a scalar value in sql?
What is use of term?
