Hi Mohammed,

The following will give you a Cursor of all names in a table where the last name occurs more than once:

SELECT UPPER(lastname) AS lastname ;
   FROM mytable ;
   GROUP BY 1 ;
   HAVING COUNT(*) > 1 ;
   INTO CURSOR firstpass_cursor

SELECT mytable.* ;
   FROM firstpass_cursor, mytable ;
   WHERE UPPER(mytable.lastname) = firstpass_cursor.lastname ;
   INTO CURSOR secondpass_cursor ;
   ORDER BY firstpass_cursor.lastname

Hope this helps,
Gavin...

>I want sql command of query
>
>
>I want name of all the persons whos last name is same in the table
>
>Plese help me
>
>
>Thanks
>Mohammed