Solved

Find largest number in a select query

Posted on 2004-04-25
1
704 Views
Last Modified: 2008-11-21
Hi

In a select query which i am doing i get rows of integers (in a column), how can i retrieve the largest integer out of them?

e.g.

|Integers|
------------
9
------------
8
------------
4
------------
45


How would i retrive the number 45
0
Comment
Question by:Ravi Singh
1 Comment
 
LVL 14

Accepted Solution

by:
psadac earned 50 total points
ID: 10912704
very easy :  SELECT MAX(integers) FROM mytable
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now