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 is a self join ?
What is embedded sql what are its advantages?
explain the difference between myisam static and myisam dynamic. : Sql dba
how to check server status with 'mysqladmin'? : Sql dba
I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.
how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c
Why we use joins in sql?
Write a query to get 2nd maximum salary in an employee table ?
69 Answers Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP,
What is cross join sql?
Where do we use pl sql?
How to change the order of columns in Oracle SQL Plus ?
Explain exception handling in pl/sql?