Interested to Buy Any Domain ? << Click Here >> for more details...
i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks
i need 1st dd for evry wk
- 1 Answers
- 6325 Views
- Aspire, I also Faced
- E-Mail Answers
Answer / kavitha singh
select year,week,date1,to_char(date1,'Day') day
from
(
select year, week,
next_day( to_date( '04-jan-' || year, 'dd-mon-yyyy' ) + (week-2)*7, 'mon' ) date1
from (select '2011' year, rownum week from all_objects where rownum <= 53 ))
| Is This Answer Correct ? | 10 Yes | 1 No |
What are the qualities of 2nf?
What found sql?
What is the usage of NVL?
7 Answers Infosys, Micro Infotek,
define primary key & secondary key?
how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.
Explain the working of foreign key?
How to run sql*plus commands in sql developer?
What are pl/sql packages?
How long does it take to learn pl sql?
Does sql backup shrink transaction log?
what are null values? : Sql dba
What is sql dialect?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
