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


Please Help Members By Posting Answers For Below Questions

Why do we create stored procedures & functions in pl/sql and how are they different?

698


What is type and rowtype in pl sql?

741


What are different methods to trace the pl/sql code?

745


What is sql and also describe types of sql statements?

760


what is the difference between clustered and non clustered index in sql? : Sql dba

742


What is java sql drivermanager?

747


What is a sql schema used for?

730


Is mariadb a nosql database?

769


What does pragma mean?

715


Explain the rollback statement?

770


What is a database event trigger?

804


What is the difference between partition and index?

663


how can we know the number of days between two given dates using mysql? : Sql dba

751


Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

749


Is sql workbench free?

720