How to display all Friday's in a year with date?
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
Which query operators in sql is used for pattern matching?
is mysql query is case sensitive? : Sql dba
What does select count (*) mean in sql?
Describe types of sql statements?
What is trigger in sql? Explain
what happens if null values are involved in expressions? : Sql dba
Does truncate need commit?
what are the nonstandard string types? : Sql dba
How do I view output in sql developer?
What is assignment operator in pl sql?
what is the difference between sql and t-sql? : Transact sql
Is sql a oracle?
How many subqueries can be nested in a statement?
What is ttitle and btitle?
What are transaction and its controls?