Click here to Skip to main content
15,895,538 members

Comments by An@mik@ (Top 20 by date)

An@mik@ 7-Apr-23 6:02am View    
I did this but I am not getting the things I want. If you can submit the code it will help to me
An@mik@ 20-Mar-23 4:36am View    
Thank you it works.
An@mik@ 14-Mar-23 4:33am View    
If you see the data Retail column is from retail Table and cinema ID 4 is not there in retail Table
and If I join then no data will show.

so if this is the situation then it should display 0. Can you give me practical query demo so I can Execute.

I used join but not getting desire result.
with CTE (ID,Month_name , TSOLD)
as
(
select
cinema.Cinema ,
MONTH_name ,
TicketsSold from cinema
where TicketsSold =
(select MAX(TicketsSold) from cinema)
)

select
cte.ID,
CTE.Month_name ,
TSOLD ,
RetailSold ,
cinema
from CTE inner join retail
on cte.Month_name = retail.Month_name

An@mik@ 4-Aug-19 14:15pm View    
for last call of dda it show the wrong output
An@mik@ 4-Aug-19 14:08pm View    
I improve my question and write the code.