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
- 10603 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
what is innodb? : Sql dba
List different type of expressions with the example.
What are the built in functions of sql?
What is a sql trace file?
What type of join is sql join?
Explain the purpose of %type and %rowtype data types with the example?
Difference between global and parameter variables?
What is the use of pl/sql table?
how to run 'mysql' commands from a batch file? : Sql dba
what is the difference between cluster and non cluster index? : Sql dba
What is the difference between between and in condition operators?
What does 0 mean in sql?
What language is oracle sql developer?
Why indexing is needed?
What is the difference between delete and truncate statement in sql?
