I have two questions.
How can I realize this query in C-Embedded SQL?
SELECT MAX (score)
WHERE uname = 'xxxxxxx'
AND exam_id IN
( SELECT exam_id
WHERE name = 'yyyy'
I used DECLARE CURSOR and FETCH for second SELECT statement.
But I don't know how to use WHERE ... IN clause.
I need to create weekly report. I would like to ask users to enter just
one date (for example, Monday of the week).
How can I select information from database for a whole week?
pgsql-interfaces by date
|Next:||From: Tom Lane||Date: 1999-02-25 15:01:53|
|Subject: Re: [INTERFACES] What's that query limit again? |
|Previous:||From: Mark Himsley||Date: 1999-02-25 10:05:34|
|Subject: Re: [INTERFACES] What's that query limit again?|