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)
Answer Posted / jprakash025
SQL> select ename,hiredate from emp
2 where
3 to_char(hiredate,'day') like '%sunday%';
ENAME HIREDATE
---------- ---------
WARD 22-FEB-81
SCOTT 19-APR-87
i dont hv monday data, thats y i m using sunday
Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
What is procedure and function in sql?
Can we join 3 tables in sql?
What is scalar function in sql?
Is it possible to pass parameters to triggers?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Why do we need databases?
Define tables and fields in a database
Do we need commit after truncate?
What do you mean by table in sql?
what is a composite key ? : Sql dba
How does join work in sql?
What are the most important characteristics of pl/sql?
What is use of package in pl sql?
What is sql scripting?
how to get a list of indexes of an existing table? : Sql dba