OraFAQ Forum: SQL & PL/SQL » Answer the query

Home » SQL & PL/SQL » SQL & PL/SQL » Answer the query (Oracle 11g Query)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Answer the query [message #669160]

Thu, 05 April 2018 11:03

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

Report message to a moderator

Re: Answer the query [message #669161 is a reply to message #669160]

Thu, 05 April 2018 12:38

Michel Cadot
Messages: 68785
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: Answer the query [message #669167 is a reply to message #669160]

Fri, 06 April 2018 08:04

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Lokesh with 2000 is the answer.

QED.

Report message to a moderator

Previous Topic:	UNUSABLE INDEX on Partition table
Next Topic:	Spell out numbers to words

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 13 15:26:14 CDT 2026