Database?

Question

If i have a table with the following fields name,Id,balance,date of registration,county and balance how will i select the rows with the maximum and minimum balances only ..by row i mean containing all the 6 fields but only displaying the 2 people with the minimum and maximum balances

Answer 1

Look into MIN() and MAX() functions: https://www.w3schools.com/sql/sql_min_max.asp

Answer 2

Along with what Shamima mentioned, check for inner joins, since a table can join itself, or another approach would be simple inner queries, (which is another way to inner join), using a where balance equals MIN balance, and salary equals a query in parenthesis that brings the balance where balance equals MAX balance. Just an idea that should work if implemented properly, Good luck Arnold.