What is window clause?

Answer Posted / dinesh

window clause are used in analytic Function.
window clause are two type ROW and RANGE

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain alias in sql?

769


Can we insert data into view?

680


Why do we use procedures in pl sql?

721


What are the different parts of a package?

812


What are the usages of sql?

752






what is the difference between clustered and non clustered index in sql? : Sql dba

737


What are sql*plus environment variables?

772


What is rowid in sql?

675


What is the difference among union, minus and intersect?

731


What is the example of procedure?

678


What is meant by truncate in sql?

752


Can we use two order by clause in query?

738


How to run pl sql program in mysql?

681


What is dense_rank?

697


What's the procedure?

665