Write a query to find the name of employees those who have
joined on Monday.(based on column hire_date)
- 15 Answers
- 38748 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
Why do we use subquery?
how can we find the number of rows in a table using mysql? : Sql dba
What is AUTH_ID and AUTH_USER in pl/sql ?
How to select 10 records from a table?
How do you drop a trigger?
What is the difference between a procedure and a function?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
Mention what are different methods to trace the pl/sql code?
How can get second highest salary in sql?
Explain the difference in execution of triggers and stored procedures?
How many tables can a sql database have?
What is %rowtype in pl sql?
List the different type of joins?
How do you use a while loop in pl sql?
What is pl sql commands?
