Write a query to find the name of employees those who have
joined on Monday.(based on column hire_date)
- 15 Answers
- 38744 Views
- Satyam, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What are the different schemas objects that can be created using pl/sql?
What trigger means?
What does a pl/sql package consist of?
What is before and after trigger?
tell me about various levels of constraint. : Sql dba
What is the use of index in sql?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
what are the differences between require and include, include_once and require_once? : Sql dba
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
How to change sql*plus system settings?
What is the difference between a primary key and a clustered index?
Why do we use set serveroutput on?
give the syntax of grant and revoke commands? : Sql dba
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
What is restrict in sql?
