select ename, sal
from emp
where sal in (select min(sal) from emp)
/





Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Dr. Eric J. Smith is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Pitchai Siva (GE Infra Energy Non-GE)
[mailto:oracledba-ezmlmshield-x29369014.[Email address protected]
Sent: Monday, March 31, 2008 9:07 AM
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

Oracle LazyDBA home page