suresh

• Jun 21st, 2006

 

select distinct id,name,salary from (give the table name here);

Bapi

• Jun 29th, 2006

 

You need to take rowid into account. you can try the below query.

Select id, name, sal from emp where rowid in select min(rowid) from emp group by id;

rabbi

 Profile Answers by rabbi 

• Jul 3rd, 2006

 

Table Name is TEST
The SQL can be.....

select avg(id), name, min(salary) from test group by name

Sarfaraz Ahmad Khan

• Jul 18th, 2006

 

select id,name,salary from <tablename> where rowid not in(seelct max(rowid) from <tablename> group by id)

dev

• Sep 13th, 2006

 

SQL> select min(id),name,min(salary) from xyz group by name;

Imran_Javed

 Profile Answers by Imran_Javed 

• May 9th, 2008

 

SELECT
  id,
  name,
  MIN(sal)
FROM
  test_emp   GROUP BY id,name;

nis1981

 Profile Answers by nis1981 

• Aug 10th, 2008

 

select t1.id, t1.name, t1.sal
from test t1, test t2
where t1.id = t2.id
and t1.sal < t2.sal;