Write a query to find the name of employees those who have
joined on Monday.(based on column hire_date)

Answer Posted / kavitha nedigunta

select ename
from emp
where trim(to_char(Hiredate,'day')) ='monday'

Is This Answer Correct ?    19 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where is all the data on the internet stored?

552


Which join is like inner join?

559


What is pivot in sql?

510


What is the order of sql select?

572


What is database migration?

517






What is difference between hql and sql?

503


How do I count duplicates in sql?

545


Why is %isopen always false for an implicit cursor?

568


Is sql considered coding?

567


What is a parameter query?

621


What is Materialized View? In What Scenario we Use Materialized View?

8515


What is sql character function?

539


What do you understand by pl/sql cursors?

546


What is snowflake sql?

578


What's the procedure?

490