Database

<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

Colin Angus Mackay wrote:

depends on the database you are using

internal sealed class Program
{
  private static void Main()
  {
    double v5 = 90807364313.118401000000000000;
    decimal v6 = 90807364313.118401000000000000m;
  
    Console.WriteLine( v5 ); // Outputs 90807364313.1184
    Console.WriteLine( v6 ); // Outputs 90807364313.11840100000000000
  }
}