Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 715
  • 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

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