What is difference between group by and partition by?


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

Post New Answer

More SQL PLSQL Interview Questions

display null value rows with out using null function?

8 Answers   Infosys,


using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.

4 Answers   Fidelity,


Is subquery faster than join?

0 Answers  


While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?

2 Answers   HSBC,


how will be date change into string

4 Answers  






hi..........i m Accenture employee...Accenture is an IT company having itz branches in India at Mumbai, Pune,Delhi, Hyderabad, Chennai and Bangalore....Presently there are openings here for SAP, Testing, Oracle,Java,.NET,MAinframe and Peoplesoft...... I am a software engineer working with Accenture,Mumbai....u can mail me in your resume..i`ll forward it to our HR team...my mail id: pankit.lodaya@accenture.com

8 Answers   Wipro,


Is and as keyword in pl sql?

0 Answers  


What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

6 Answers   Cap Gemini, TCS,


What is a trigger ?

11 Answers   Accenture, BirlaSoft,


which command using query analyzer will give you the version of sql server and operating system? : Sql dba

0 Answers  


What is user defined functions?

0 Answers  


What is sqlexception in java?

0 Answers  


Categories