SELECT ENAME FROM EMP WHERE TO_CHAR(TO

Write a query to find the name of employees those who have
joined on Monday.(based on column hire_date)

Question Posted / mahendar reddy

15 Answers
41197 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

Please Help Members By Posting Answers For Below Questions

What does sql stand for?

1001

what is a trigger in mysql? Define different types of trigger. : Sql dba

1074

What does where 1 1 mean in sql?

1046

What is a variable in sql?

1007

What is package in pl sql?

1030

What is schema in sql example?

1187

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1105

Is keyword pl sql?

1012

Explain scalar functions in sql?

1074

how to load data files into tables with 'mysqlimport'? : Sql dba

1100

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1139

What are the sql aggregate functions?

1138

What is trigger with example?

1104

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1010

What are pl/sql cursors?

1058