Siva,
What kind of data is there in column "No". Please provide some sample...
Thanks & Regards,
Manash Partim Baruah
MS-LCS| DBA| Tech Mahindra Ltd.
Sharda Center, 6th Floor Annex Building, Pune-4, India
www.techmahindra.com
-----Original Message-----
From: Pitchai Siva (GE Infra Energy Non-GE)
[mailto:oracledba-ezmlmshield-x29369014.[Email address protected]
Sent: Monday, March 31, 2008 6:37 PM
To: LazyDBA Discussion
Subject: is there any way to find the minimum value from non numeric
column in Oracle?
Hi all,
I am facing one problem in oracle
That is I have a table (test11) it has two columns (no,name), both
columns has to be defined as the varchar2 data type.
The column No having numeric data as well as character data, I want to
fetch the minimum value of NO from that table, for that I have written
the below query but its not returned the correct record
Select min (no), name from test11 group by name
So please suggest me that how can retrieve the minimum value of NO from
that table?
Thanks and Regards,
Siva.P
Bangalore
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
============================================================================================================================
Disclaimer:
This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.
============================================================================================================================
Oracle LazyDBA home page