Home » SQL & PL/SQL » SQL & PL/SQL » Help with questions i'm tying to validate from interview (SQL newest version)
Help with questions i'm tying to validate from interview [message #677906] Mon, 21 October 2019 22:07 Go to previous message
jricks
Messages: 1
Registered: October 2019
Junior Member
Can someone please help me with these questions? These were interview questions i just want to make sure i got right.

1: Pull all loans with the highest app_value
2: Pull all loans with Borr_name & first App_value
3: Update all records with Null date to todays date
4: Build query to pull only loans that start with the letter B and all matching App_Values
5: Display only loans and show the 2nd highest app_value



Table A
Loan_Num App_Value Date
123 100 1/1/2000
456 750 6/30/2015
123 150 4/1/2018
987 100 NULL
456 725 7/31/2015
123 200 NULL

Table B
Loan_Nbr Borr_Name
0123 Bob
4311 Jake
0678 Sam
0789 James
0456 Jordan
0126 Ben
0987 Sara
 
Read Message
Read Message
Previous Topic: Interval Partition table on Date column with SYSDATE as value (merged)
Next Topic: Exist Value in a table
Goto Forum:
  


Current Time: Thu Jan 23 04:58:22 CST 2020