Need help on select query
HI All,
I have a table with 4 columns like name, primary acct.no, secondary acct.no and branch name. I need to select the record only when the primary acct.no and secondary acct.no is different. kindly help me on this select query.
table structure
Name PAcctNo SAcctNo Branch
ABC 0001 0001 DEF
ABD 0002 0003 ERF
DER 0004 0005 RET
I have to write a query such that i have to select only the second row.Kindly help me on this query.
Thanks in Advance,
Arul.
|