SQl Query for the Problem?

Question

Hi Friends,

I have the below problem in writing an sql query.

Assume we have a table with two columns.the pattern being

col1 col2

X 1
X 2
Y 3
Y 4
Z 5
Z 6
This is the pattern there are n no of rows having same value in col1 and different value in col2.I need to write a query which feach me the rows having least value in col2(comparision between the two records)

The required solution is

col3 col4
X 1
Y 3
Z 5

Answer 1

hi ok here is what you need

select col1, min(col2) from table
group by col1

this will result in displaying only those entries from col1 that have the minimum cal2 value.

Note: you would want to make the col2 an integer data type. I assume you know that. Also if you want it be sorted by col1 use the "Order by" clause.

Answer 2

Hi,
Suppose ur table name is tab1 then write the following SQL query

Select col1, min(col2) from tab1 group by col1

Answer 3

select col1,min(col2) from table_name group by col1