摘要:
程序事例:日志信息:二手车 1345二手房 3416洗衣机 2789输入: N=2输出:二手房洗衣机map函数如下:import java.io.IOException;import java.util.Map;import java.util.TreeMap;import org... 阅读全文
摘要:
Given a non-negative number represented as an array of digits, plus one to the number.The digits are stored such that the most significant digit is at... 阅读全文
摘要:
Given a sorted array, remove the duplicates in place such that each element appear only once and return the new length.Do not allocate extra space for... 阅读全文
摘要:
Rotate an array of n elements to the right by k steps.For example, with n = 7 and k = 3, the array [1,2,3,4,5,6,7] is rotated to [5,6,7,1,2,3,4].Note:... 阅读全文
摘要:
Given a sorted integer array without duplicates, return the summary of its ranges.For example, given [0,1,2,4,5,7], return ["0->2","4->5","7"].Java代码如... 阅读全文
摘要:
Given a linked list, remove the nth node from the end of list and return its head.For example, Given linked list: 1->2->3->4->5, and n = 2. After ... 阅读全文
摘要:
SELECT cust_name, cust_contact FROM customersWHERE cust_id IN (SELECT cust_id FROM orders #单独写多个分句,最后组成一个. WHERE order_num IN (SELECT... 阅读全文
摘要:
SELECT vend_id, COUNT(*) AS num_prods FROM products #GROUP BY子句可以包含任意数目的列,多行NULL值将分为一组GROUP BY vend_id; #GROUP BY子句必须出现在WHERE子句之后,ORDER BY子句之前。SELECT ... 阅读全文
摘要:
SELECT AVG(prod_price) AS avg_price FROM products; #AVG只能用于单个列求平均值,如想计算多个列,必须用多个AVG()SELECT AVG(prod_price) AS avg_price FROM productsWHERE vend_id = ... 阅读全文
摘要:
#文本处理函数SELECT vend_name, Upper(vend_name) AS vend_name_upcase FROM vendorsORDER BY vend_name;SELECT cust_name, cust_contact FROM customersWHERE Sounde... 阅读全文