Postgres Pro
Downloads
Home   >   mailing lists

HOW SELECT - Mailing list pgsql-general

From shyju c.k
Subject HOW SELECT
Date
Msg-id 628fd60a0608250050j40d0b350r421021841ee4be3c@mail.gmail.com
Whole thread Raw
Responses Re: HOW SELECT  (Ragnar <gnari@hive.is>)
List pgsql-general
Tree view
hai all
 
 
      i have table  ,as follows
 
--------------------------------------------------------------------------------------------------------------
|        id_int          |        vid_int         |        name_chv      |       address_txt  |
-------------------------------------------------------------------------------------------------------------
|        2               |          12             |        ram               |       address1      |
--------------------------------------------------------------------------------------------------------------
|        3               |         12              |        joy                |       address2      |
--------------------------------------------------------------------------------------------------------------
|        4              |          14              |        shyju            |       address3      |
-------------------------------------------------------------------------------------------------------------
|        5              |          14              |        shyju             |       address4      |
-------------------------------------------------------------------------------------------------------------
|        6              |          30              |        thomas          |       address5      |
-------------------------------------------------------------------------------------------------------------
|        7             |           30               |        muhamd         |       address6     |
------------------------------------------------------------------------------------------------------------
|        8             |           30              |        rahim              |       address7     |
-------------------------------------------------------------------------------------------------------------
 
 
here only vid_int=14 ,  have  name=shyju repeated   
 
[ how query for list  the following records ]
 
--------------------------------------------------------------------------------------------------------------
|        id_int          |        vid_int         |        name_chv      |       address_txt  |
-------------------------------------------------------------------------------------------------------------
|        4               |          14             |        shyju             |       address3      |
-------------------------------------------------------------------------------------------------------------
|        5               |         14              |        shyju             |       address4      |
-------------------------------------------------------------------------------------------------------------
 
 
Advance thanx
 
REGARDS
SHYJU
 

pgsql-general by date:

Previous
From: Rafal Pietrak
Date:
Subject: Re: multimpe records output from a 'no-table' source
Next
From: Achilleas Mantzios
Date:
Subject: CMS - portal server Question