I have table with entries as follows

Col-1 Col-2 Col-3 Col-4 Col-5

Fname loginID uniqueID logintime duration
abc a12 1234 2011_06_22_00_00 4
fcl a12 1234 2011_06_22_00_00 4
happu a12 1234 2011_06_22_00_15 4
samle a12 1234 2011_06_22_00_00 4
abc b12 234 2011_06_22_00_10 4
abar b12 234 2011_06_22_00_00 4
samt b12 234 2011_06_22_00_15 4
acer c2 1239 2011_06_22_00_00 4
sony c2 1239 2011_06_22_00_00 4

Result format:
list of Fname's group wise....
I need those Fname's having same loginID, uniqueID, logintime, duration but different Fname's

Query should give the results in this format
set-1
abc
fcl
samle
set-2
happu
set-3
abc
abr
set-4
samt
set-5
acer
sony

Hi Chavala,

Try this,

select * from Tbl_name
where uniqueID=uniqueId and loginID=loginID
group by Fname,loginID
order by loginID,logintime

Thank you,

But i need ouputs in a set of groups...not as single column....
each match should give a set of feature names....

sorry, but that is not what you asked for

you clearly said "I need those Fname's having ..."

if you want "set of groups" you will have to explain what this means

Thank you for your help........NP
Reason why i need in a groups is that....
each group of Fname will results into one unique catagory

so...

add some more columns to the SELECT clause

other approach will be....

col-1 col-2
A 1
A 2
A 3
B 3
B 2

I want to write a query which can give me out as A if values in col-2 is 1,2,3

I have written a query
select col-1 from table where col-2='1' and col-2 = '2' and col-3 = '3';
When i execute the query I am getting empty string.....
I think we may not be able to write AND operator for same Column....
I don't know how to solve this....

well, actually, you ~can~ write it, but as you have discovered, it always returns no rows

that's because a single column value cannot be equal to more than one thing at a time

the solution is to use GROUP BY, so that you are writing conditions in the HAVING clause that pertian to all the rows in the group

the conditions will involve counting the separate values, and then ANDing the conditions such that each count has to be greater than 0

Thank you,
I am unable to trace the condition to write in Having clause...
counting the seperate values..?

the specifications are right here

for each col1 (which is your GROUP BY column), you want to count at least one '1' in col2, and at least one '2' in col2, and at least one '3' in col2

that's what you want to count

for example,will give you the count of rows where col2='1'

Thank you...