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
- 10694 Views
- I also Faced
- E-Mail Answers
Answer Posted / l meher
SQL> select ename,hiredate from emp where trim(to_char(trunc(hiredate),'DAY')) = 'MONDAY';
ENAME HIREDATE
---------- ---------
MARTIN 28-SEP-81
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What is rename in sql?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
Which one is faster ienumerable or iqueryable?
Can we join 3 tables in sql?
What are tables and fields in the database?
Enlist the data types that can be used in pl/sql?
differentiate between float and double. : Sql dba
Can triggers stop a dml statement from executing on a table?
How can I tell if sql is running?
How many types of tables are there?
Can we rollback truncate?
Define select, insert, create, delete, update, drop keywords
What are the two different parts of the pl/sql packages?
What is the difference between clustered and non-clustered indexes?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
