select firstname,lastname from hire_date where sdate='Monday'

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

Question Posted / mohammad murtuza ali

Answer Posted / mohammad murtuza ali

select firstname,lastname from hire_date where
sdate='Monday'
(or)
select firstname,lastname from hire_date where
sdate='27022010'

Is This Answer Correct ?

8 Yes

15 No

Please Help Members By Posting Answers For Below Questions

Explain what is an index?

1038

How does sql developer connect to oracle database?

986

What is delete command in sql?

1090

What are the different types of a subquery?

1035

What do you understand by pl/sql cursors?

1074

Difference between table function and pipelined function?

1004

What is database migration?

951

How delete all records from table in sql?

964

What is a natural join?

1048

how do you control the max size of a heap table? : Sql dba

960

Can we rename a column in the output of sql query?

981

Explain what is a database?

1078

Does execute immediate commit?

1199

Does pl sql work in mysql?

955

what are numeric data types? : Sql dba

1051