• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 716
  • Last Modified:

Find largest number in a select query

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
Ravi Singh
Asked:
Ravi Singh
1 Solution
 
psadacCommented:
very easy :  SELECT MAX(integers) FROM mytable
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

Tackle projects and never again get stuck behind a technical roadblock.
Join Now