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
- 41497 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / ajeet
select last_name,to_char(hire_date,'day,mm,yyyy')
from employees
where trim(to_char(Hire_date,'day')) ='monday'
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is multiple partition?
Is postgresql a nosql database?
Where can I learn sql for free?
Why do we create stored procedures & functions in pl/sql and how are they different?
What are the types of variables use in pl sql?
What will you get by the cursor attribute sql%found?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What is primary key sql?
What is implicit cursor in pl sql?
Why do we use joins?
What are the steps for performance tuning.
Does truncate require commit?
What is difference between group by and partition by?
what is bcp? When is it used?
What do you mean by field in sql?
