Page 1 of 1
Maximum and Minimum JOBNO in a project
Posted: Wed Oct 18, 2006 4:39 pm
by ecclesr
I am trying to find the minimum and maxium JOBNO is a project
SELECT MAX(JOBNO) FROM DS_JOBS;
Returns 999
But the actual number i was expecting was 2677 ??
Thanking you all in advance
Posted: Wed Oct 18, 2006 4:52 pm
by ray.wurlod
That's because JOBNO has a data type of VarChar. Try:
Code: Select all
SELECT MAX(CAST(JOBNO AS INTEGER)) FROM DS_JOBS;
or
Posted: Wed Oct 18, 2006 7:38 pm
by kumar_s
Ray - Everytime you give out some new stuff. May I know what 'DET.SUP' used in your query for. Is it to suppress the Description information?
Posted: Wed Oct 18, 2006 7:53 pm
by chulett
Detail Suppression. Run the query with and without and you shall see, my young Padawan.
Posted: Wed Oct 18, 2006 8:55 pm
by Prashantoncyber
Can anybody suggest where (mean any pdf or doc) list of such kinds of commands can be found out.
thanks
Posted: Wed Oct 18, 2006 11:25 pm
by ray.wurlod
Posted: Thu Oct 19, 2006 2:23 am
by rameshrr3
Do a google on "Universe ODBC guide" and it will lead you to quite a few other useful documents.
HTH
Ramesh
Posted: Thu Oct 19, 2006 3:20 am
by kumar_s
chulett wrote:Detail Suppression. Run the query with and without and you shall see, my young Padawan.
Thats obvious from you, Jedi Master.
Posted: Thu Oct 19, 2006 7:58 am
by chulett
I defer that title to Ray... err, I mean Mr Wurlod.
![Wink :wink:](./images/smilies/icon_wink.gif)
Posted: Thu Oct 19, 2006 8:53 am
by ray.wurlod
Unlike Yoda I don't put verbs at the ends of sentences. Unless in Latin, of course.