Questions tagged [highest]
134 questions
-1
votes
1 answer
SQL - finding hour with highest values - busy hour
I have a table with 15min resolution in every 24 hour and looking to extract an hour with highest value which is sum of the highest four 15 minutes
I can find greatest value, but need to have four consecutive 15 minutes which give the highest hour…
Amir Ahmadi
- 1
- 4
-1
votes
1 answer
Returning second highest element of a list using just a for loop and Len() method
I need two different ways for getting the second highest value of an int from a list by just using one for loop and the Len() method. No other functions are allowed for my approach.
sorted(numbers)[-2]
This was my approach, but as you can see I…
Codingissomuchfun
- 35
- 4
-1
votes
2 answers
Calculate the highest 2 & 3 values returned from functions
Within a class I have 4 functions which return individual values (see code below).
I need to add 2 additional functions which calculate the total of the following:-
The total of the 2 highest numbers
The total of the 3 highest numbers
These totals…
ColinL
- 15
- 4
-1
votes
1 answer
Get user with highest points
I want to get the User with the highest points in SQL. I have this Table:
userId
points
1
1
2
0
3
4
1
1
3
2
2
5
Now, I want to get the userId where the points are highest? In this example it where user 3, but how I can do this…
magiccoder
- 3
- 3
-1
votes
2 answers
How to print only the last line of this output?
I need to find the longest row of non primes below 10000.
How to print only that last line that's in my output ?
Without max function and without simple numerical constraint.
I think it only needs some small adjustment, just don't see where or…
Casper A
- 1
- 2
-1
votes
1 answer
given how can i use scala to print out the highest rated movie for each user?
input file
(userid,movie,rating)
1,250,3.0
1,20,3.4
1,90,2
2,30,3.5
2,500,2.3
2,20,3.3
I am supposed to to get the highest rated movie the user rated. I am completely lost,I had the program running on hadoop but i am brand new to scala. It is…
troy
- 3
- 2
-1
votes
2 answers
How do i get the Average, Highest and Lowest of values from a listbox and then display it on a textbox
I have the following code, how can I get the values from the items in the listbox and get my program to find the average, highest and lowest of the values. I currently have the following textboxes (averageTextbox, highestTextbox, lowestTextbox) and…
Relaxsingh
- 11
- 5
-1
votes
1 answer
Subset by highest value of a variable (R)
How can I create a subset by the highest value of a certain variable in a data frame?
I have the following dataframe, from which I want to extract the highest value of V1 by name:
name V1 V2
1 name1 1 f
2 name1 2 b
3 name1 5 c
4 name2 3 …
xyz
- 134
- 1
- 12
-1
votes
10 answers
3rd highest salary sql
I try to get all 3 highest salary from top 5 employees like this
salary
35000
34000
20000
12000
500
40000
25000
41000
90000
550000
query
select top 5
(SELECT MAX(grosssalary) FROM Detail) maxsalary ,
(SELECT…
super user
- 59
- 2
- 2
- 10
-1
votes
1 answer
Finding Highest , Lowest and the Average in Cobol
I am creating a program that is reading in a file which consists of companies and their information. It is to reject companies with a rating lower that 3.5 and then display the highest quote and the lowest quote and then the average among the…
otto
- 1
- 1
- 4
-1
votes
5 answers
3 Highest Numbers in an array without sorting, Where am I missing the logic?
This program is for finding 3 highest numbers in an array.
When I run the code, I'm getting first highest and second highest. And second highest is getting repeated for third number
What am I missing in the…
Pravin Hanchinal
- 29
- 1
- 6
-1
votes
2 answers
Select Max in a table to get name in other table SQL
I have 2 tables
Players
Pnr
Pname
Padress
Pcity
Tickets
Tnr
Pnr
Date
Costs
I want to get the name of the player with the highest Ticket Cost from the database with Select. And I want to know who has got a Ticket in May. I also want to know who…
Arjan Oskam
- 31
- 2
- 11
-1
votes
1 answer
Excel function for removing duplicates with a lower rank
I receive a fuel consumption report each month. The report contains up to 600 vehicles, during the reporting period the same vehicle could fill up only once or multiple times resulting in duplicate entries with assending odometer readings.
I need to…
user3474533
- 13
- 1
-1
votes
2 answers
How to compare data in session with PHP?
The $_SESSION has the following data array.
Array (
[totalprice] => 954
[cart] => Array (
[115] => Array (
[name] => MÅNESKINN
[price] => 268.00
[count] => 1 )
[80] => Array (
[name] => DELFINLEK
[price] =>…
shin
- 31,901
- 69
- 184
- 271
-1
votes
1 answer
Get the highest value from a variable using bash script
I am trying to extract the highest number from $countip and copy it to $totalip, the problem is that $totalip is allways returning 0. Can anybody help me please, i am new to bash script.
for srcip in `cat /var/log/messages | grep "WACSLAW1 CRITICAL…
gomesg
- 243
- 1
- 2
- 4