What is sorting in sql?
No Answer is Posted For this Question
Be the First to Post Answer
what is oracle database ? : Sql dba
How many types of cursors supported in pl/sql?
Can I create table without primary key?
How to pronounce postgresql?
How will we see framework of a table?
What is primary key and unique key?
how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000
Can we group by two columns in sql?
can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?
Is sql open source?
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;
write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh