This week's book giveaway is in the OCMJEA forum. We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line! See this thread for details.
You have a problem because your set of results is not really a set. Relational Databases work on the assumption that tables are sets of tuples - i.e. every row is unique (because its defined by a primary key). This isn't true for the results you show. You want to show a result which is data for an empno - but empno is not unique. Hence you can't do it (and there's no bit of SQL you could use to get round this in any safe way).
If you have a table that is showing the type of data you list, I'd suspect that this is a result of a model that has not been properely normalized. If you can, I'd possibly rethink the DDL for this entity.