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
- 40994 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / venkat
Select first_name,Last_name
from employees
where To_date('HIREDATE','D')=2;
1-SUNDAY
2-MONDAY
----
7-SATURDAY
The advantage of the above query even don't know about the
format of day of the week We get the output.
Monday,
MON
MONDAY
ETC
| Is This Answer Correct ? | 6 Yes | 7 No |
Post New Answer View All Answers
what is the difference between undefined value and null value? : Sql dba
What are reports usually used for?
Explain architecture of sql server notification services?
How to get help at the sql prompt?
Does sql use python?
What is db journal file?
Can we use rowid as primary key?
what is oracle database ? : Sql dba
How much does a sql dba make? : SQL DBA
Define implicit and explicit cursors.
Explain the types of joins in sql?
Is pl sql a scripting language?
What plvcmt and plvrb does in pl/sql?
What is index example?
what is top in tsql? : Transact sql
