Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10597 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 19 null in sql?
Can we use delete in merge statement?
What will you get by the cursor attribute sql%notfound?
what is 'mysqld'? : Sql dba
What are local and global Indexes and where they are useful.
How can we solve sql error: ora-00904: invalid identifier?
how many ways to get the current time? : Sql dba
What are the set operators in sql?
What is blind sql injection?
How can you save or place your msg in a table?
What is the trigger in sql?
How to run pl/sql statements in sql*plus?
What are the different types of joins in sql?
how to present a past time in hours, minutes and seconds? : Sql dba
How do I know if I have sql express or standard?
