Question: Write down the equivalent SQL query requested in the following piece of code (3 marks): String table = goal ; String[] columns = new String[]
- Write down the equivalent SQL query requested in the following piece of code (3 marks):
String table = "goal"; String[] columns = new String[] { "distinct id", "date", "sum(goal)" }; String selection = "id=? and date=?"; String[] arguments = new String[] { "0", "Sep 15, 2015" }; String groupBy = "id, date"; String having = null; String orderBy = null; db.query(table, columns, selection, arguments, groupBy, having, orderBy);
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help