What are analytical functions in sql?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?

1 Answers   Pitney Bowes,


TABLE A TABLE B EMPNO ENAME EMPNO ENAME 1 A 1 A 2 B 2 B 3 C 3 C 4 D 4 D 5 E 5 E 6 F 7 G HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?

10 Answers   Satyam,


Can pl sql procedure have a return statement?

0 Answers  


Is the primary key an index?

0 Answers  


Can delete statement be rollbacked?

0 Answers  






how are mysql timestamps seen to a user? : Sql dba

0 Answers  


What is the use of function "module procedure" in pl/sql?

0 Answers  


Show the cursor attributes of pl/sql.

0 Answers  


Explain commit, rollback and savepoint.

0 Answers  


Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

0 Answers   TCS,


What is left join in postgresql?

0 Answers  


What is difference between my sql and sql?

0 Answers  


Categories