Ask About SQL - Mailing list pgsql-sql
From | Otniel Michael |
---|---|
Subject | Ask About SQL |
Date | |
Msg-id | 1703cd180908190317p3b1c4140hc9cbe41331c0725e@mail.gmail.com Whole thread Raw |
Responses |
Re: Ask About SQL
("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: Ask About SQL (Joshua Tolley <eggyknap@gmail.com>) |
List | pgsql-sql |
<span style="color: rgb(51, 51, 255);">Hi All.</span><br style="color: rgb(51, 51, 255);" /><br style="color: rgb(51, 51,255);" /><span style="color: rgb(51, 51, 255);">Can help to create sql queries for this data :</span><br style="color:rgb(51, 51, 255);" /><br style="color: rgb(51, 51, 255);" /><span style="color: rgb(255, 0, 0);">tabel A</span><brstyle="color: rgb(255, 0, 0);" /><span style="color: rgb(255, 0, 0);">field1, field2, field3</span><br style="color:rgb(255, 0, 0);" /><span style="color: rgb(255, 0, 0);">x1, y1, 5</span><br style="color: rgb(255, 0,0);" /><span style="color: rgb(255, 0, 0);">x1, y2, 1</span><br style="color: rgb(255, 0, 0);" /><span style="color:rgb(255, 0, 0);">x2, y1, 2</span><br style="color: rgb(255, 0, 0);" /><span style="color: rgb(255, 0,0);">x2, y3, 4</span><br style="color: rgb(255, 0, 0);" /><span style="color: rgb(255, 0, 0);">x1, y3, 4</span><br style="color: rgb(51, 51, 255);" /><br style="color: rgb(51, 51, 255);" /><span style="color: rgb(51,51, 255);">I want to get 2 record with the max value at field3 for each kombination of field1 :</span><br style="color:rgb(51, 51, 255);" /><br style="color: rgb(51, 51, 255);" /><span style="color: rgb(255, 0, 0);">tabel B</span><brstyle="color: rgb(255, 0, 0);" /><span style="color: rgb(255, 0, 0);">field1, field2, field3</span><br style="color:rgb(255, 0, 0);" /><span style="color: rgb(255, 0, 0);"> x1, y1, 5</span><br style="color: rgb(255,0, 0);" /><span style="color: rgb(255, 0, 0);"> x1, y3, 4</span><br style="color: rgb(255, 0, 0);" /><spanstyle="color: rgb(255, 0, 0);"> x2, y3, 4</span><br style="color: rgb(255, 0, 0);" /><span style="color: rgb(255,0, 0);"> x2, y1, 2</span><br style="color: rgb(51, 51, 255);" /><br style="color: rgb(51, 51, 255);" /><spanstyle="color: rgb(51, 51, 255);">Anyone have an ideas?</span><br style="color: rgb(51, 51, 255);" /><span style="color:rgb(51, 51, 255);">Thanks anyway.</span><br clear="all" /><br />-- <br />-------------------------------------------------------------------<br/> "He who is quick to become angry will commit folly,and a crafty man is hated"<br />