Here we use minimum as a column for the result know whether it displays only in the output or it stores (add) in the employee

Question

SELECT MIN(Salary) AS mimimum FROM employees;

Answer 1

lucky , don't know which one is best but I used xampp. It's also mentioned in sololearn SQL course.

You can search net or try this code made by AJ
https://code.sololearn.com/WQRToD2o8Raq/?ref=app

Answer 2

lucky ,
original table will remain unaffected.

select statement is a means of retrieving data from DB. You'll generally use DML statements (insert, update, delete etc.) for modifying contents of DB.

select will retrieve and display the data (minimum salary in this case) without affecting any other table or the queried table itself (however it can be another case if you have any triggers associated with tables)

It'll be better to try using these queries rather than guessing or asking these basics. keep practicing!

Answer 3

Ok 👍

Answer 4

Ok bruh TQ ! Which one is best to practice sql on laptop ?