Write a query to find the name of employees those who have
joined on Monday.(based on column hire_date)
Answer Posted / emmanuel
Select * from emp
Where to_char(TO_DATE(hire_date),'day')='monday';
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the basic form of sql query?
Is sql injection illegal?
Is a secondary key the same as a foreign key?
what is a unique key ? : Sql dba
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
Define union, minus, union all, intersect ?
What is spool?
Do we need commit after truncate?
How does postgresql compare to mysql?
What's the difference between inner join and left join?
Are subqueries faster than joins?
Explain the purpose of %type and %rowtype data types?
What are sql indexes?
What is the difference between delete, truncate and drop command?
How to fetch alternate records from a table?