Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find the name of employees those who have
joined on Monday.(based on column hire_date)
- 15 Answers
- 41168 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / venkat
Select first_name,Last_name
from employees
where To_date('HIREDATE','D')=2;
1-SUNDAY
2-MONDAY
----
7-SATURDAY
The advantage of the above query even don't know about the
format of day of the week We get the output.
Monday,
MON
MONDAY
ETC
| Is This Answer Correct ? | 6 Yes | 7 No |
Post New Answer View All Answers
Why primary key is required?
What are the 3 types of behavioral triggers?
How exception handling is done in advance pl/sql?
What is the use of primary key?
What are expressions?
Why do we use sql constraints?
What are the different datatypes available in PL/SQL?
Can you selectively load only those records that you need? : aql loader
what are the advantages of mysql in comparison to oracle? : Sql dba
Why is pl sql needed?
What is a left inner join?
What is sql and db2?
Determine if oracle date is on a weekend?
Explain ddl statements in pl/sql?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
