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

Does asenumerable execute the query?

773


Explain aggregate functions are available there in sql?

748


Can we rollback after truncate?

746


Which command is used to call a stored procedure?

710


What are the most important ddl statements in sql?

743






What is synchronized subquery?

817


what is a composite primary key ? : Sql dba

779


What is the max nvarchar size?

676


i have some prob lem to tell me about my self in interview first round ...

1886


What is difference between mysql and postgresql?

703


Can sql function call stored procedure?

732


what are the different functions in sorting an array? : Sql dba

761


What is a sql trace file?

731


How many types of tables are there?

690


What is delimiter in pl sql?

737