Search
 
SCRIPT & CODE EXAMPLE
 

SQL

select other columns with distinct

SELECT * FROM table
WHERE id IN (
  SELECT MAX(id) FROM table GROUP BY name
)
Comment

PREVIOUS NEXT
Code Example
Sql :: postgress if 
Sql :: sql server remove 0 from left 
Sql :: mysql create table if not exists 
Sql :: alter boolean column postgresql 
Sql :: mysql search replace 
Sql :: copy from one table to another postgres using matching column 
Sql :: SQL Server OPENJSON FROM table column 
Sql :: postgresql powershell query 
Sql :: show specific events on mysql 
Sql :: postgres select except 
Sql :: lost connection to mysql server during query when dumping table 
Sql :: select only distinct values from another table and excluding from current table 
Sql :: what data type to use for phone number in sql 
Sql :: stored procedure sql 
Sql :: sql highest salary by location 
Sql :: SQL Server Splitting a string column into multiple rows, while repeating ID column 
Sql :: devilbox mysqldump 
Sql :: create postgres role and database for bitbucket 
Sql :: hour must be between 1 and 12 
Sql :: get comma separated values in mysql with group by 
Sql :: collation in sql 
Sql :: mysql get table column names and data types 
Sql :: how to login to mysql as normal user in ubuntu 
Sql :: how to verify sequence result in oracle SQL 
Sql :: max mysql 
Sql :: add column first position mysql 
Sql :: Pl/Sql table based record 
Sql :: example database query 
Sql :: mysql sleep connections 
Sql :: drop table oracle 
ADD CONTENT
Topic
Content
Source link
Name
4+1 =