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
Can you have more than one trigger on a table?
The select into statement is most often used to create backup copies of tables or for archiving records?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
How can we make an if statement within a select statement?
How to get help at the sql prompt?
Which software is used for pl sql programming?
What is the difference between instead of trigger and after trigger?
What is %s in sql?
What are all different types of collation sensitivity?
What is difference between inner join and cross join?
How does postgresql compare to "nosql"?
What is the usage of distinct keyword?
how is myisam table stored? : Sql dba
How do I run sql profiler?
How do you pronounce sql?
