Write a query to find the name of employees those who have
joined on Monday.(based on column hire_date)
- 15 Answers
- 38751 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / arun kumar reddy
select * from
(select emp.*,to_char(to_date(hiredate),'day') as join_day from emp)
where join_day like'mo%';
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is a recursive join sql?
Explain the steps needed to create the scheduled job?
How can you fetch common records from two tables?
Write a query to display the current date in sql?
What if we write return in procedure?
What does sql stand for?
What is a system versioned table?
What are the three pl sql block types?
How can you create an empty table from an existing table?
Why we use joins in sql?
what is the difference difference between procedure and packages
How to change the order of columns in Oracle SQL Plus ?
Can primary key be changed?
How to create your own reports in sql developer?
What are the advantages of pl sql over sql?
