How to display all Friday's in a year with date?
- 4 Answers
- 6582 Views
- Flipkart, I also Faced
- E-Mail Answers
Answer Posted / kuldeep
select * from
(
SELECT (TRUNC (SYSDATE, 'yyyy') + LEVEL - 1) dt,
TRIM(TO_CHAR ((TRUNC (SYSDATE, 'yyyy') + LEVEL - 1), 'Day')) dy
FROM DUAL
CONNECT BY LEVEL <= 365
)
where dy='Friday'
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are secondary keys?
What are commit, rollback, and savepoint?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
Can we insert data into view?
What is data types in sql?
what is not null constraint? : Sql dba
What type of database is cloud sql?
Is sql considered coding?
What does subquery mean in sql?
What is a null value?
What are data types in pl sql?
What program will open a mdb file?
What is the primary use of normalization?
How do you exit in sql?
Is sqlite good enough for production?
