Write a query to find the name of employees those who have
joined on Monday.(based on column hire_date)
Answer Posted / ravindra
Select first_name,Last_name
from employees
where To_date('Hire_date','Day')='Monday'
| Is This Answer Correct ? | 6 Yes | 21 No |
Post New Answer View All Answers
What are sql procedures?
What is the difference between database trigger and stored procedure?
How do you copy a table in sql?
What is cursor and its types?
how are mysql timestamps seen to a user? : Sql dba
Why stored procedure is faster than query?
What is field delimiter?
What's the difference between a primary key and a clustered index?
What is meant by user defined function?
What is sql partition?
what is the command used to fetch first 5 characters of the string? : Sql dba
What is the difference between drop and truncate commands?
what are the advantages of mysql in comparison to oracle? : Sql dba
How is a process of pl/sql compiled?
What are the basic techniques of indexing?