/SQL/Find lowest number in sql

Find lowest number in sql

Find lowest number in sql

SELECT first_name, last_name, salary, job_id
FROM employees
WHERE salary = (SELECT MIN(salary) FROM employees);

0

Select lowest values sql

SELECT * FROM MyTable
ORDER BY MyCol ASC  LIMIT 100

0

Source: stackoverflow.com

Similar codes

0 vote247 views1 answer
Convert multiple columns to ROws in sql server
SQL
2 votes250 views2 answers
Sql percentage
SQL
0 vote457 views1 answer
Power bi connect to postgresql
SQL
4 votes244 views3 answers
Postgres set default value
SQL
1 vote274 views1 answer
Alter database datafile maxsize 32g
SQL
0 vote223 views1 answer
Add column to table with default value plsql
SQL
10 votes251 views2 answers
SQL rounding numbers
SQL
1 vote240 views1 answer
Set statiscis on in ssms
SQL
3 votes233 views1 answer
Mysql load sql from file
SQL
5 votes196 views1 answer
Alter table default value mysql
SQL

Share