Write a query to find the name of employees those who have
joined on Monday.(based on column hire_date)
- 15 Answers
- 38717 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / chaitu
select ename,to_char(hiredate,'Day') from emp
where trim( to_char(hiredate,'Day'))='Monday'
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How would you convert date into julian date format?
What is a constraint?
What is t sql used for?
Can we use update in sql function?
Is left join same as inner join?
How do I start sql from command line?
What are pl/sql cursor exceptions?
what are ddl statements in mysql? : Sql dba
How to change the order of columns in Oracle SQL Plus ?
Is sql free?
What does desc stand for?
What is the difference between stored procedure and view?
What are types of indexes in sql?
What are the different type of joins in sql?
What is triggering circuit?
