a doubt in sql please help me

[vinoth888]

IN sql a select statement should display stars as given below

*
**
***
****

the stars should be displayed in the form of a triangle

please give a solution for this..

[debasisdas]

Kindly post what you have tried so far .

[vinoth888]

a sql query that should display * in the form of a triangle for a table

ans :
[code=oracle]

select lpad('*',rownum ,'*') from table_name where rownum<=6

[/code]

[amitpatel66]

Your query seems to be fine. It should be working. Any issues in executing that query?