Interested to Buy Any Domain ? << Click Here >> for more details...
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
- 0 Answers
- 1110 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between join and union.
27 Answers 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global,
What does := mean in pl sql?
What are tables in sql?
Is left join inner or outer?
What does (+) mean in sql joins?
What is user in sql?
4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;
What is normalisation in sql?
What is the least restrictive isolation level? : Transact sql
what are null values? : Sql dba
What are the disadvantages of not performing database normalization?
what is the command used to fetch first 5 characters of the string? : Sql dba
-
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)
