What is partition by in sql?
No Answer is Posted For this Question
Be the First to Post Answer
What are the advantages of pl sql over sql?
What is record in pl sql?
Define union, minus, union all, intersect ?
What are tables and fields?
Which is faster count (*) or count 1?
write sub query for eliminating duplicate rows using analytical function?
Which one is better subquery or joins?
What are the difference between Functions/Stored Procs and Triggers and where are they used.
How do I kill a query in postgresql?
From an Employee table, how will you display the record which has a maximum salary?
29 Answers Cap Gemini, Exilant, Synechron,
I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?
What is minus?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)