Write a query to find the name of employees those who have
joined on Monday.(based on column hire_date)
- 15 Answers
- 38716 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / kiran kumar
SELECT * FROM EMP
where TRIM(TO_CHAR(TRUNC(HIREDATE),'DAY'))='SUNDAY'
| Is This Answer Correct ? | 23 Yes | 7 No |
Post New Answer View All Answers
What is bitemporal narrowing?
How can I make sql query run faster?
What is sql and explain its components?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is trigger types of trigger?
How do I view a sql database?
Can a varchar be a primary key?
What is a database? Explain
What is before and after trigger?
Why do we use joins?
Can you select everything, but 1 or 2 fields, without writer's cramp?
What is data abstraction in sql?
Which join is like an inner join?
What does select count (*) mean in sql?
What is a dynamic query?
