Hi, Is it possible to pass all columns of a table as arguments to a function in a implicit way?
I tried this but it did not work: Create table studentMarks (French, English, Maths, Physics); Insert into studentMarks values (12, 9, 15, 14); Insert into studentMarks values (14, 13, 12, 8); Select max(*) from studentMarks where French > 13; I could always iterate from my code and build an explicit argument list for the max function, but I'm lazy and I'm intrigued... Is there a way to do this? "*" is a strange animal in SQL. Sometimes it means "all rows" as in: Select count(*)... Sometimes it means "all columns" as in: Select * from table where... Thanks, Jean-Denis _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
