Mysql display values if i have only user entered value
By : user6560797
Date : March 29 2020, 07:55 AM
wish help you to fix your issue this should do it (assuming your 'data' column is in fact a datetime, and your user input is a string). Two separate queries to get the lower and upper values, then join together with UNION : code :
(SELECT * FROM myTable WHERE STR_TO_DATE('07.11.1986', '%d./%m./%Y') < data ORDER BY data ASC LIMIT 1)
UNION ALL
(SELECT * FROM myTable WHERE STR_TO_DATE('07.11.1986', '%d./%m./%Y') > data ORDER BY data DESC LIMIT 1)

How do I save the values that the user enters in this indefinite loop to be used later to find the largest and smallest
By : richard chilcott
Date : March 29 2020, 07:55 AM
will be helpful for those in need Well, how about you take each user input, and...add it to a list? Wow, I know, cutting edge. Then, I don't know, maybe do some operations on that list that find the min and max? Here's an example. If this is homework, you're better off rewriting for yourself. And if you're using Python 2.x, as your updated question indicates, you're going to have to modify what I'm giving you either way, because it is for Python 3 code :
numberlist=[] #where we're storing our data
while True:
print("Please enter a number, or 'Done'")
newdata=input()
if newdata == 'done' or newdata == 'Done' or newdata == 'DONE': #only gave options here because I typed the wrong case in while testing
break #breaks the loop when done is entered
numberlist.append(newdata) #adds the number entered to our list
print("List of numbers: "+str(numberlist))
print("Min: "+min(numberlist))
print("Max: "+max(numberlist))

how find the angles of a triangle with values that the user enters and how to draw it
By : Abraxas
Date : March 29 2020, 07:55 AM
Hope that helps Going through a bit at a time: although wildcard imports are generally frowned upon, it is more usual syntax to use code :
from turtle import *
from math import *
import math
a = float(input("enter the value for a: "))
b = float(input("enter the value for b: "))
c = float(input("enter the value for c: "))
if (a + b >= c) and (b + c >= a) and (c + a >= b):
print("it's a triangle")
else:
print("it's not a triangle")
A = degrees(acos((b**2 + c**2  a**2)/(2*b*c)))
B = degrees(acos((c**2 + a**2  b**2)/(2*c*a)))
C = degrees(acos((a**2 + b**2  c**2)/(2*a*b)))
from turtle import *
from math import *
import math
a = float(input("enter the value for a: "))
b = float(input("enter the value for b: "))
c = float(input("enter the value for c: "))
if (a + b >= c) and (b + c >= a) and (c + a >= b):
print("it's a triangle")
A = degrees(acos((b**2 + c**2  a**2)/(2*b*c)))
B = degrees(acos((c**2 + a**2  b**2)/(2*c*a)))
C = degrees(acos((a**2 + b**2  c**2)/(2*a*b)))
else:
print("it's not a triangle")

Java: Display the complete set of unique values input after the user enters each new value
By : user1609527
Date : March 29 2020, 07:55 AM

find the user entered value or sum the row values
By : Toni
Date : March 29 2020, 07:55 AM
Any of those help You can find all combinations of 1 or two invoices that meet your conditions: code :
select d1.invoice, d1.price,
(case when d2.invoice <> d1.invoice then d2.invoice end) as invoice2,
(case when d2.invoice <> d1.invoice then d2.price end) as price2
from data d1 left join
data d2
on d1.invoice <= d2.invoice
where (d1.price = 500 and d2.invoice = d1.invoice) or
(d1.price + d2.price) = 500

