Community

Query to fetch one row only doesn’t work when part of a view

(Craig Mullins) I have a condition where I have to select only the first row from a SQL query. select b.status from credit_source a,credit b, credit_Status c where a.credit_source_id = b.credit_source_id and b.status = c.status order by c.weight desc fetch first rows only This statement

Read More - Register for Free Membership

Tags: