Home » SQL & PL/SQL » SQL & PL/SQL » Answer the query (Oracle 11g Query)
Answer the query [message #669160] Thu, 05 April 2018 11:03 Go to next message
Lokesh A
Messages: 1
Registered: April 2018
Junior Member
Find the highest balance containing account holder name:

Account Table Columns(ID is primary key)
Account
-------------
ID Name
1 Lokesh
2 Aakash
3 Mahesh

Account Details Table Columns(ID is Primary key, AID is foreign key)
-------------------------------
ID AID Balance
11 1 500
12 2 1000
13 3 100
14 1 1500
15 1 2000
Re: Answer the query [message #669161 is a reply to message #669160] Thu, 05 April 2018 12:38 Go to previous messageGo to next message
Michel Cadot
Messages: 67363
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Welcome to the forum.
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" or "Preview Quick Reply" button to verify.

With any SQL or PL/SQL question, please, Post a working Test case: create table (including all constraints) and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.

Re: Answer the query [message #669167 is a reply to message #669160] Fri, 06 April 2018 08:04 Go to previous message
joy_division
Messages: 4949
Registered: February 2005
Location: East Coast USA
Senior Member
Lokesh with 2000 is the answer.

QED.
Previous Topic: UNUSABLE INDEX on Partition table
Next Topic: Spell out numbers to words
Goto Forum:
  


Current Time: Mon Sep 21 14:02:41 CDT 2020