answersLogoWhite

0


Best Answer

Using a left join of:

SELECT a.number FROM table a, table b WHERE a.number < b.number

where right table.number is null

User Avatar

Wiki User

13y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you find maximum in SQL without using MAX function?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Which is the maximum num from 2 num find without using and?

max= a&gt;b? a: b;


How do you find the length of string without using strlen function in MySQL?

SELECT char_length (...) FROM ...


How do you find the minimum or maximum of a function?

By taking the derivative of the function. At the maximum or minimum of a function, the derivative is zero, or doesn't exist. And end-point of the domain where the function is defined may also be a maximum or minimum.


Write a flowchart to find the sum of maximum and minimum o N natural numbers without using arrays?

huh?


How do you get a maximum displacement?

To determine the maximum displacement, you need to calculate the peak value of the displacement function. This is done by finding the extreme values (maximum or minimum) of the function, typically by taking the derivative and setting it to zero to find critical points. Once you have these critical points, evaluate the function at those points to find the maximum displacement.


How do you determine the range of a function?

Find the maximum and minimum values that the function can take over all the values in the domain for the input. The range is the maximum minus the minimum.


How do you find the minimum and maximum points of a function?

Set the first derivative of the function equal to zero, and solve for the variable.


C plus plus code to find the length of a string without using function?

int i = 0; while(str[i] != NULL){ i++; }


How can you use the zeros of a function to find the maximum or minimum value of the function?

You cannot. The function f(x) = x2 + 1 has no real zeros. But it does have a minimum.


How do you find maximum or minimum of a function?

y=2x2-3x2-12x+5=0


How do you find minimum and maximum value of calculus?

In Calculus, to find the maximum and minimum value, you first take the derivative of the function then find the zeroes or the roots of it. Once you have the roots, you can just simply plug in the x value to the original function where y is the maximum or minimum value. To know if its a maximum or minimum value, simply do your number line to check. the x and y are now your max/min points/ coordinates.


How do you find the range using the subtraction method?

Range = Maximum - Minimum