How to display all Friday's in a year with date?
- 4 Answers
- 5917 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 the packages in pl sql?
how can we know the number of days between two given dates using mysql? : Sql dba
How to test for null values?
Is a secondary key the same as a foreign key?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
what is the use of set statement in tsql? : Transact sql
Which is the correct statement about truncate and delete?
Why use triggers in sql?
What is the maximum number of triggers, you can apply on a single table?
How do I start sql from command line?
Is sql dba a good career? : SQL DBA
Does sql require a server?
can a stored procedure call itself or recursive stored procedure? : Sql dba
How many triggers can be applied to a table?
is mysql query is case sensitive? : Sql dba
