/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

2 votes296 views1 answer
When matched in sql server
SQL
18 votes268 views2 answers
Sql comments
SQL
0 vote274 views1 answer
Remove default constraint sql server
SQL
6 votes273 views3 answers
Mysql first day of year
SQL
0 vote287 views1 answer
Selecting Data in SQL - Select Data
SQL
11 votes280 views2 answers
Oracle all source
SQL
0 vote269 views1 answer
Sql view index
SQL
5 votes307 views1 answer
Oracle nls session
SQL
-1 vote297 views1 answer
Concat two columns in sql server
SQL
0 vote288 views1 answer
Sql server roles and users
SQL

Share