/SQL/How to select the lowest values from table per client sql

How to select the lowest values from table per client sql

Sql select lowest value row

SELECT t1.*
FROM employees t1
INNER JOIN (
    SELECT id, min(salary) AS salary FROM employees GROUP BY id
) t2 ON t1.id = t2.id AND t1.salary = t2.salary;

How to select the lowest values from table per client sql

SELECT DISTINCT
						t1.CompliancyID ,t1.[Status],t1.FK_ClientID
					FROM #VettingCompliance  t1
					INNER JOIN 
					(
					SELECT FK_ClientID, min(CompliancyID) AS CompliancyID FROM #VettingCompliance GROUP BY FK_ClientID
					) t2 ON t2.CompliancyID = t1.CompliancyID AND t1.FK_ClientID = t2.FK_ClientID

-1

Similar codes

7 votes398 views4 answers
Index in mysql
SQL
-1 vote390 views1 answer
Create view in mysql workbench
SQL
3 votes359 views1 answer
Oracle revoke grant
SQL
16 votes338 views2 answers
Gremove folder from git
SQL
0 vote358 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote366 views1 answer
Sql check for null and empty string
SQL
12 votes445 views6 answers
Change mysql root password
SQL
4 votes405 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote390 views1 answer
View psql output in horizontal scrolling
SQL
3 votes366 views1 answer
Force using index plsql
SQL