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 | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

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

SELECT MIN(Salary) AS mimimum FROM employees;

19th Dec 2019, 5:45 PM
Lakshmi Reddy Sanikommu
Lakshmi Reddy Sanikommu - avatar
4 Answers
+ 2
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
20th Dec 2019, 1:58 AM
๐Ÿ‡ฎ๐Ÿ‡ณOmkar๐Ÿ•‰
๐Ÿ‡ฎ๐Ÿ‡ณOmkar๐Ÿ•‰ - avatar
+ 1
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!
19th Dec 2019, 6:07 PM
๐Ÿ‡ฎ๐Ÿ‡ณOmkar๐Ÿ•‰
๐Ÿ‡ฎ๐Ÿ‡ณOmkar๐Ÿ•‰ - avatar
+ 1
Ok ๐Ÿ‘
20th Dec 2019, 2:07 AM
Lakshmi Reddy Sanikommu
Lakshmi Reddy Sanikommu - avatar
0
Ok bruh TQ ! Which one is best to practice sql on laptop ?
20th Dec 2019, 1:42 AM
Lakshmi Reddy Sanikommu
Lakshmi Reddy Sanikommu - avatar