What do you want to save?
Add Code snippet
New code examples in category SQL
-
Awgiedawgie 2022-05-13 23:00:31
sql get most recent record
# Use the aggregate MAX(signin) grouped by id. This will list the most recent signin for each id. SELECT id, MAX(signin) AS most_recent_signin FROM tbl GROUP BY id # To get the whole single record, perform an INNER JOIN against a subquery which retu... Add solution -
Phoenix Logan 2022-05-13 22:35:29
azure sql server check foreign key
select schema_name(fk_tab.schema_id) + '.' + fk_tab.name as foreign_table, '>-' as rel, schema_name(pk_tab.schema_id) + '.' + pk_tab.name as primary_table, substring(column_names, 1, len(column_names)-1) as [fk_columns], fk.name as fk_c... Add solution
Best helpers
Ranking is empty