Home » SQL & PL/SQL » SQL & PL/SQL » traingle qery
traingle qery [message #390998] Tue, 10 March 2009 11:17 Go to next message
kommerashashi
Messages: 23
Registered: November 2007
Junior Member
Hi every one,


Gud evening ....
i have a doubt in sql ...
is it possible to write the query to get the output as


trainagle shape ...like


1
1 2 1
1 3 3 1
1 4 6 4 1



if possible ...can u tell me how to write the query ....




thanks in advance,

regards,

Shashi
Re: traingle qery [message #391000 is a reply to message #390998] Tue, 10 March 2009 11:18 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.

Post DDL for tables.
Post DML for test data.

Post expected/desired results.
Re: traingle qery [message #391004 is a reply to message #390998] Tue, 10 March 2009 11:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As first step, have a look at Puzzle n°08 - Display the Numerical Pyramid using straight SQL query, then post what you succeed.

Regards
Michel
Re: traingle qery [message #391115 is a reply to message #391000] Wed, 11 March 2009 01:42 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
BlackSwan wrote on Tue, 10 March 2009 17:18
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.

Post DDL for tables.
Post DML for test data.

Post expected/desired results.

Please stop these default responses. It is clear from the question (well, it's clear to me anyway) that there is no DDL/DML involved here, nor a testcase.
Previous Topic: Slow query with rownum
Next Topic: select data within 2 different database
Goto Forum:
  


Current Time: Tue Dec 06 14:03:15 CST 2016

Total time taken to generate the page: 0.10199 seconds