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
- 40844 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / nitin umale
SELECT last_name,TO_CHAR(hire_date, 'Day,dd-Mon-yy')Hire_date
FROM employees
WHERE UPPER(TRIM(TO_CHAR(hire_date, 'day')))='MONDAY';
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Does truncate need commit?
How many types of relationship are there?
What is the current version of postgresql?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
Explain the significance of the & and && operators in pl sql.
Can you select everything, but 1 or 2 fields, without writer's cramp?
What is a dynamic query?
What is bulk compiling in pl/sql.?
Is merge a dml statement?
List the ways to get the count of records in a table?
What are some emotional triggers?
What is trigger explain with example?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
What trigger means?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
