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
- 41166 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / priya
select firstname,lastname from hire_date where to_upper
(to_char(hire_date, 'mon')) = 'MON' ;
since hire_date is of date type converting the date to
again of date type is of no use.Need to convert it to
string type and select the month.
| Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
what is the difference between $message and $$message? : Sql dba
Is sql a backend language?
How can one get sql*loader to commit only at the end of the load file? : aql loader
What are the types of join and explain each?
what are the differences among rownum, rank and dense_rank? : Sql dba
Define join and name different types of joins?
how can we know the count/number of elements of an array? : Sql dba
Why schema is used in sql?
What is a left join?
What is meaning of <> in sql?
What is a sql profiler?
What is rowid in sql?
When do we use triggers?
How to convert comma separated string to array in pl/sql?
What is the use of triggers?
