Viewing 15 posts - 61 through 75 (of 104 total)
oracle plsql using on ms sql
August 23, 2012 at 3:41 am
friends ,
select top 2*
from empy order by cast(sal as int)desc
in these query has given first two max values, now i need the ouput while i am giving the position...
August 17, 2012 at 4:32 am
ya its workin..... suppose i need the particular top 3rd postion of max salary means how to modify
August 17, 2012 at 3:55 am
not working the ROW_NUMBER(), and DENSE_RANK() function in server 2000
August 17, 2012 at 3:02 am
for above that for E2674 account total value of credit, total value of debit for each month
July 30, 2012 at 1:46 am
Hi,
Above the my procedure query giving output,i m splitting the amount column has credit and debit,closing_bal column is sum of account is E=>debit-credit,
...
July 27, 2012 at 3:24 am
hey friend my actual table ve lakhs of data per month,after making the query,I m expexting ve to display account only one time per month and its has been summarize...
July 27, 2012 at 2:47 am
account PR_Mons credit debit closinbal
=======================================
E2674 apr 3000 00000 -3000
R7890 jun ...
July 27, 2012 at 12:27 am
create table report
(
account varchar(30),
trans char(30),
trans_date date,
amount number(50)
)
insert into report(account,trans,trans_date,amount) values('E2674','Cr','02apr02',300)
insert into report(account,trans,trans_date,amount) values('R7890','Dr','06jun11',5000)
insert into report(account,trans,trans_date,amount) values('E9700','Cr','7feb09',5000).......
insert into report(account,trans,trans_date,amount) values('R7890','Cr','06jun11',5900)
insert into report(account,trans,trans_date,amount) values('E9700','Dr','7feb09',8000)
now i need the output of display for...
July 26, 2012 at 11:05 pm
hi friend.
when i am using DATEPART() its shows the month number(april,4),But i need the month name..... while i m using DATENAME() function giving the same month number only in...
July 25, 2012 at 6:06 am
hi ,
I'm created procedure but doesnt given the expecting ouput,show sum errors
MYQUERY:
=========
CREATEprocedure PP__POSTINGS
(
@x datetime,
@y datetime
)
as
begin
select
account
...
July 25, 2012 at 3:24 am
how can split month coumn from date...would please give me brief
July 25, 2012 at 2:25 am
Viewing 15 posts - 61 through 75 (of 104 total)