ramanindya55
New User
Joined: 23 May 2008
Posts: 9
Location: pune
|
|
|
|
Hi,
I want to write a query for checking any existence of any row.
Can u plz tell me which one would be best considering the Performance parameter?
| Code: |
EXEC SQL
SELECT COUNT(*)
INTO :stud-count
FROM Student
WHERE Degree = :WS-Degree
END-EXEC.
|
Here is my "Select 1" query
| Code: |
EXEC SQL
SELECT 1
INTO :stud-count
FROM Student
WHERE Degree = :WS-Degree
END-EXEC.
|
|
|
