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 next 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
Re: Help with questions i'm tying to validate from interview [message #677907 is a reply to message #677906] Mon, 21 October 2019 22:21 Go to previous message
BlackSwan
Messages: 26640
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

>i just want to make sure i got right.
So what were your answers?
Please post them here for review.
Previous Topic: Interval Partition table on Date column with SYSDATE as value (merged)
Next Topic: Exist Value in a table
Goto Forum:
  


Current Time: Sat Dec 07 04:21:22 CST 2019