SQL Coding Exercise – Delete Duplicate Emails
Write a SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its smallest Id. +----+------------------+ | Id | Email …
Author: ACMer
SQL Coding Exercise – Rising Temperature
Given a Weather table, write a SQL query to find all dates’ Ids with higher temperature compared to its previous (yesterday’s) dates. +---------+------------+------------------+ | Id(INT) | Date(DATE) | Temperature(INT) …
Linux Bash Coding Exercise – Get the Tenth Line of File
How would you print just the 10th line of a file? For example, assume that file.txt has the following content: Line 1 Line 2 Line 3 Line 4 Line …
C++ and Python to Compute the Pascal Triangle
Given an index k, return the k-th row of the Pascal’s triangle. For example, given k = 3, Return . Could you optimize your algorithm to use only O(k) …
How to Search Twits with Pictures/Images using PHP?
If you want to search twits with Pictures or Images using PHP, then the following script is right for you. First you would need to set up the Twitter …