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
- 41015 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / ravindra
Select first_name,Last_name
from employees
where To_date('Hire_date','Day')='Monday'
| Is This Answer Correct ? | 6 Yes | 21 No |
Post New Answer View All Answers
How do I remove duplicates in two columns?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What is a trigger word?
what are the different type of normalization? : Sql dba
How delete all records from table in sql?
What is database migration?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What is the difference between view and stored procedure?
Which sql statement is used to delete data from a database?
What are commit, rollback, and savepoint?
What is a recursive join sql?
Define join and name different types of joins?
What is difference between mysql and postgresql?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
Are subqueries faster than joins?
