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
- 41159 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / arun kumar reddy
select * from
(select emp.*,to_char(to_date(hiredate),'day') as join_day from emp)
where join_day like'mo%';
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Is primary key always clustered index?
What are % type and % rowtype?
What is the sql case statement?
What are sql indexes?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
What is scalar function in sql?
What is blind sql injection?
Why use triggers in sql?
what are aggregate and scalar functions? : Sql dba
Explain raise_application_error.
Mention what are the benefits of pl/sql packages?
Which type of cursor is used to execute the dml statement?
What is the main difference between sql and pl/sql?
List and explain the different types of join clauses supported in ansi-standard sql?
When you have to use a default "rollback to" savepoint of plvlog?
