SQL: Find duplicates

posted in: SQL | 0

Description To find duplicate entries in your database Example SELECT a.firstname, a.lastname, a.address FROM list a INNER JOIN list b ON a.address = b.address WHERE a.id b.id

Restful API – Handling large amounts of data

posted in: API, Data | 0

Summary: You can change your API to include additional parameters to limit the scope of data returned by your application. You could add limit and offset parameters to fetch just a little part. myapi.co.uk/messages?limit=10&offset=20 Another way to decrease the payload would … Continued

1 2