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
- 40999 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
what is meant by nl2br()? : Sql dba
How many triggers can be applied to a table?
How can we link a sql database to an existing android app?
What is sqlcontext?
What is data modelling in sql?
what is 'mysqladmin' in mysql? : Sql dba
What is the source code of a program?
Can pl sql procedure have a return statement?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
what is normalization? : Sql dba
How much does sql cost?
what happens if you no create privilege in a database? : Sql dba
Which command is used to delete a package?
What is sql integrity?
Is sqlite good enough for production?
