1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / guest


i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that..

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

Post New Answer

More SQL PLSQL Interview Questions

How can I pass the inner procedure value to outer procedure ?

2 Answers  

Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN

2 Answers  

Can we use ddl commands in pl sql?

0 Answers  

What is difference between joins and union?

0 Answers  

How do we use distinct statement? What is its use?

0 Answers  




What is the use of sqlerrd 3?

0 Answers  

Why do we use %rowtype & %type in plsql?

0 Answers  

Difference between IN and EXISTS

4 Answers   Nous, Polaris,

How do you break a loop in pl sql?

0 Answers  

how to fetch common records from two tables? : Sql dba

0 Answers  

what is bdb (berkeleydb)? : Sql dba

0 Answers  

Is left join faster than join?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories