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
- 40652 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
How do you declare a variable in pl sql?
What are the different type of joins in sql?
How many aggregate functions are available there in sql?
Mention what pl/sql package consists of?
What is scalar function in sql?
How global cursor can be declare with dynamic trigger ?
Are dml statements autocommit?
What is embedded sql with example?
How to execute a stored procedure?
What are all ddl commands?
how to create a new table in mysql? : Sql dba
Write a sql select query that only returns each name only once from a table?
How to call shell script from pl sql procedure?
What is a full join?
Can we use rowid as primary key?
