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

How do I know if I have sql express or standard?

1038

How many types of literals are available in pl sql?

1122

What is sql clause?

1055

Can you select everything, but 1 or 2 fields, without writer's cramp?

986

Explain what is dbms?

1071

What is pl sql architecture?

964

what is data integrity? : Sql dba

1042

What does pl sql stand for?

1121

If a cursor is open, how can we find in a pl/sql block?

1168

Are pl sql variables case sensitive?

1053

What is not equal in sql?

1131

How to place comments in pl/sql?

1168

what is oltp (online transaction processing)? : Sql dba

1082

What does inner join mean?

1175

what is index? : Sql dba

1010