SQL Language (MOSC)

MOSC Banner

Need SQL Query

edited May 21, 2013 10:35PM in SQL Language (MOSC) 3 commentsAnswered ✓
Hi SQL Experts,
Need help in getting below output :

create table sales_tab
(
sales_date date,
sales number
)
;

insert into sales_tab values('01-MAY-2013',101);
insert into sales_tab values('02-MAY-2013',102);
insert into sales_tab values('03-MAY-2013',103);
insert into sales_tab values('04-MAY-2013',104);
insert into sales_tab values('05-MAY-2013',105);
insert into sales_tab values('06-MAY-2013',106);
insert into sales_tab values('07-MAY-2013',107);
commit;


Need SQL query to get output like below.



SALES_DAT      SALES  SALES_DAT_prev   SALES_prev
--------- ------------------- ---------- ----------

07-MAY-13        107   06-MAY-13        106
06-MAY-13        106   05-MAY-13        105
05-MAY-13        105   04-MAY-13        104

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center