SQL Recipes
A FREE cookbook for SQL queries and examples
Register FAQ Search Today's Posts Mark Forums Read

SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it.

Go Back   SQL Recipes a FREE cookbook of SQL queries and examples > SQL queries and examples > SQL - Questions and Answers
SQL: max value from a column? SQL: max value from a column?

Reply
 
LinkBack Thread Tools Search this Thread
  #1 (permalink)  
Old 06-28-2007, 12:44 PM
ali_hammad ali_hammad is offline
Junior Member
  
Join Date: Jun 2007
Posts: 2
ali_hammad is on a distinguished road
Default ANY dialect question:

SQL: max value from a column?

i have this data in column
1
2
33333
9999

When i do

select max(colname) from table

it always return 9999 rather than 33333(which is the actual highest value.. )

What to do??
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

ANSWER(S):

  #2 (permalink)  
Old 06-28-2007, 01:03 PM
ben ben is offline
Administrator
  
Join Date: Mar 2007
Posts: 95
ben has disabled reputation
Default ANY answer. Re: SQL: max value from a column?
What database are you using?
What is the data type for the column?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 06-28-2007, 01:20 PM
Unregistered
 
Posts: n/a
Default ANY answer. Re: SQL: max value from a column?
Set the datatype for this column to Int and that should fix your problem.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« How to use the Ref Commad? | how to find parent & child related records »

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 09:11 PM.

Contact Us - SQL Recipes - Archive - Top

Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0
Copyright (c) 2006-2008 SQL Recipes

1 2 3 4 5 6 7 8