Guest User

Untitled

a guest
Mar 22nd, 2018
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.22 KB | None | 0 0
  1. SET @old_set_id = 71, @new_set_id = 72;
  2.  
  3. SELECT id,request_id, data_capture_id as temp_id, count(data_capture_id ) as item_count
  4. FROM my_table where request_id= @old_set_id or request_id= @new_set_id
  5. GROUP BY record_col_1
Add Comment
Please, Sign In to add comment