Write a query to find the employees from EMP table those who
have joined in Monday. (there is a column as hiredate which is
a date column i.e values are like 03-DEC-81)
- 5 Answers
- 9173 Views
- I also Faced
- E-Mail Answers
Answer Posted / siva
Select* from emp where to_char(hiredate,'dy')='mon';
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sql character function?
is mysql query is case sensitive? : Sql dba
What are the key differences between SQL and PL SQL?
What is data modelling in sql?
What is sap sql anywhere?
How delete all records from table in sql?
What are field types?
Is delete faster than truncate?
What is a mutating table and a constraining table?
how to rename an existing column in a table? : Sql dba
What is null in pl/sql?
How do you update sql?
What is the use of & in pl sql?
when MSQL8.0 is in market
What is a composite primary key?
