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
- 40616 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / mahendar reddy
SELECT ENAME FROM EMP WHERE TO_CHAR(TO_DATE(HIREDATE),'D')='2';
IT fetch the employee name who joined on monday
Here
1=sunday
2=monday
--
---
--
--
--etc
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
Can we commit inside a trigger?
How many functions are there in sql?
How to run pl sql program in mysql?
What is the use of %rowtype?
What does sign mean sql?
What is the most restrictive isolation level? : Transact sql
what are myisam tables? : Sql dba
How many types of literals are available in pl sql?
What are the disadvantages of file system?
Why should I use postgresql?
What is the use of function in sql?
What is normalization in a database?
How is data stored on a disk?
Write the command to remove all players named sachin from the players table.
