HOW TO PRINT
*
**
***
****
*****
BY USING SQL QUERY? (MAY BE USING SCRIPT)

Answer Posted / kart

select lpad('*',rownum,'*') Star from person where rownum<6
*
**
***
****
*****

Is This Answer Correct ?    20 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can instead of triggers be used to fire once for each statement on a view?

537


Write a sql query to convert all character to uppercase after hypen.

960


What is localdb mssqllocaldb?

621


How to make a copy values from one column to another in sql?

576


Which is better trigger or stored procedure?

502






Why do we use subquery?

489


What is gpt format?

507


What's the procedure?

492


Do we need to rebuild index after truncate?

529


What sql database should I use?

551


What is the difference between the conventional and direct path loader? : aql loader

652


Explain the difference between drop and truncate commands in sql?

534


write an sql query to find names of employee start with 'a'? : Sql dba

579


Is sql similar to python?

538


What is the difference between python and sql?

524