database view code example

Example 1: create view

CREATE VIEW view_name AS SELECT id,category,MAX(created_at),content,title FROM table WHERE condition GROUP BY category

Example 2: table views

// for cell for row at function in a table view

 let cell = UITableViewCell()
        
        let toDos = toDo[indexPath.row]
        
        cell.textLabel?.text = toDos.name
        
        return cell