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)
Answers were Sorted based on User's Feedback
Answer / l meher
SQL> select ename,hiredate from emp where trim(to_char(trunc(hiredate),'DAY')) = 'MONDAY';
ENAME HIREDATE
---------- ---------
MARTIN 28-SEP-81
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / 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 |
Answer / pramod
select *
from tbl_employees
where DATENAME(DW,hiredate)='Monday' order by hiredate
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / siva
Select* from emp where to_char(hiredate,'dy')='mon';
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / masuduz zaman
SELECT * FROM EMP
WHERE (DATEPART(dw, HIREDATE) + @@DATEFIRST) % 7 = 2
Is This Answer Correct ? | 0 Yes | 3 No |
What are the types of variable use in pl sql?
what is meant by DML?
Explain what is a database?
What is an ndf file?
what is innodb? : Sql dba
what are the difference between clustered and a non-clustered index? : Sql dba
Is a secondary key the same as a foreign key?
What is Referential Integrity?
What is difference between mysql and postgresql?
Why commit is not used in triggers?
What is the difference between row level and statement level trigger?
Is clustered index a primary key?