Dept wise avrage salary
Answers were Sorted based on User's Feedback
Answer / suraj
select deptno,trunc(avg(sal))as avg from emp group by deptno;
| Is This Answer Correct ? | 6 Yes | 0 No |
What is a logical backup ?
What is denormalization and why would someone consider doing so?
hello to all i want code for like this site "Submit Question" page.please give answers thanks.
what is GET_BLOCK property ?
Explain the concepts of a primary key and foreign key.
What is a distributed database?
What's the difference between 'union' and 'union all' ?
What do you understand by ‘database’?
what is difference between 1.append to media 2.overright the existing media when we take back up in sql server2000
0 Answers Indian Web Technology,
What do you mean by deadlock dbms?
what are primary key and foreign key ?
What is the purpose of a database table?
Oracle (3253)
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)