Database

<code>     select name,date,
         sum(case when type='A' then value else 0 end) as 'A',
         sum(case when type='B' then value else 0 end) as 'B',
         sum(case when type='C' then value else 0 end) as 'C'
     from table1 where date=max(date)
     group by name </code>

<code>select name,max(date),
         sum(case when type='A' then value else 0 end) as 'A',
         sum(case when type='B' then value else 0 end) as 'B',
         sum(case when type='C' then value else 0 end) as 'C'
     from table_1 where date=(select max(date) from table_1)
     group by name </code>

SELECT a.name, MAX(a.dt) AS [date], <br />
    SUM(CASE WHEN type = 'A' THEN valu ELSE 0 END) AS A, <br />
    SUM(CASE WHEN type = 'B' THEN valu ELSE 0 END) AS B, <br />
    SUM(CASE WHEN type = 'C' THEN valu ELSE 0 END) AS C<br />
FROM TblB a <br />
   INNER JOIN (SELECT name, MAX(dt) AS dt FROM  tblB GROUP by name) b <br />
                                 ON a.name = b.name and a.dt = b.dt<br />
GROUP BY a.name 

Rmesh wrote:

How to write query to find relationship between the primary key and foreign key re lation ship between the tables