Write a query to find the name of employees those who have
joined on Monday.(based on column hire_date)
Answer Posted / ajit nayak
SELECT *
FROM EMP
WHERE TO_CHAR(HIREDATE,'FMDAY') = 'MONDAY';
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is trigger price?
What is rownum in sql?
What are triggers and its types?
explain advantages of innodb over myisam. : Sql dba
Explain 3 basic parts of a trigger.
How many clustered indexes can be created on a table?
Can we rollback delete command?
Which join is default?
Explain the methods used to protect source code of pl/sql.
Why use triggers in sql?
Why stored procedure is faster than query?
Is coalesce faster than isnull?
What is composite data type in pl sql?
What is trigger explain with example?
What is rename in sql?