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


Please Help Members By Posting Answers For Below Questions

What is a database event trigger?

592


What is trigger price?

538


What is data control language?

528


Does user triggers have entry for trigger with compilation errors?

592


Is sql port 1433 encrypted?

572






What is database sql?

539


Is primary key clustered or nonclustered?

556


What is java sql connection?

510


Mention what are different methods to trace the pl/sql code?

556


How do you create a db file?

518


how to select first 5 records from a table? : Sql dba

507


What is your daily office routine?

1808


What are the rules to be applied to nulls whilst doing comparisons?

750


how to return query output in html format? : Sql dba

649


what is sql? : Sql dba

557