Answer / l meher

SQL> select ename,hiredate from emp where trim(to_char(trunc(hiredate),'DAY')) = 'MONDAY';

ENAME HIREDATE
---------- ---------
MARTIN 28-SEP-81

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

Answer / pramod

select *
from tbl_employees
where DATENAME(DW,hiredate)='Monday' order by hiredate

Answer / siva

Select* from emp where to_char(hiredate,'dy')='mon';

Answer / masuduz zaman

SELECT * FROM EMP
WHERE (DATEPART(dw, HIREDATE) + @@DATEFIRST) % 7 = 2

What is normalization and types of normalization?

22 Answers   Etisbew, F-TEC, Microsoft, TechProcess,

What is where clause in sql?

0 Answers  

what are the performance and scalability characteristics of mysql? : Sql dba

0 Answers  

What is the differnce between view and materialized view

4 Answers   TCS,

What is execute immediate?

0 Answers  

what is msql? : Sql dba

0 Answers  

Can we use the cursor's to create the collection in PL/SQL?

0 Answers   MCN Solutions,

How to pipe multiline string to isql?

0 Answers  

how to see the create table statement of an existing table? : Sql dba

0 Answers  

What does select count (*) mean in sql?

0 Answers  

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance

5 Answers   Target,

what is the use of friend function? : Sql dba

0 Answers