KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Name type Age ------------------------------- Vijay 1 23 Kumar 2 26 Anand 3 29 Raju 2 23 Babu 1 21 Muthu 3 27 -------------------------------------- Write a query to update the name of maximum age person in each type into 'HIGH'. And also please tell me, why the following query is not working update table1 set name='HIGH' having age = max(age) group by type;
Tags (comma-separated)
Save Edits
Cancel