Iterate over a table and print name and age for each row.

Problem

Given a table of data with the following columns:
id
name
age
Write a cursor that will iterate over the table and print the name and age of each row.
Example input:
1, "John", 20
2, "Jane", 30
3, "Joe", 40
Example output:
John, 20
Jane, 30
Joe, 40

Solution

This solution is in SQL. Our A.I. can create solutions in multiple languages.

sarastevens

/*

The optimal solution is to use a cursor.

A cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, instead of the typical SQL commands that operate on all the rows in the set at one time.

In order to use a cursor we must:

Declare a cursor
Open a cursor
Fetch rows from the cursor
Close the cursor
Deallocate the cursor

*/

DECLARE @id INT
DECLARE @name VARCHAR(50)
DECLARE @age INT

DECLARE cursor_name CURSOR FOR
SELECT id, name, age
FROM table_name

OPEN cursor_name

FETCH NEXT FROM cursor_name INTO @id, @name, @age

WHILE @@FETCH_STATUS = 0
BEGIN
    PRINT @name + ', ' + @age
    FETCH NEXT FROM cursor_name INTO @id, @name, @age
END

CLOSE cursor_name
DEALLOCATE cursor_name