Travelling Cats
Powerbuilder, SQL, Oracle, My Little Sister & Me
Saturday, August 2, 2008
Using ROWNUM
//getting first row of result
SELECT a.nostaf, a.nama , b.department
FROM asas, khidmat b
WHERE a.nostaf = b.nostaf
AND ROWNUM = 1;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment