Answer / shiva

select sal from emp group by sal;
this query group the same salary.Suppose the table contains 30
records in that same sal is 3 times repeating by using above
query it will fetch only 27 rows of sal.So it wont give the duplicate sal.

Answer / pankajsharma

it will fetch all the salaries one tme in case of duplicacy

Answer / arun karthick

select sal from emp group by sal; and select distinct sal
from emp ;
Both queries will give the same result - fetch the salary
in emp table without duplicates.

Can we rollback after truncate?

0 Answers  

---

Types of optimization?

6 Answers   Microsoft,

---

Which data type doesn't allow null data type?

6 Answers   TCS,

---

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,

---

What is the difference between a primary key and a unique key?

0 Answers  

---

How much does sqlite cost?

0 Answers  

---

what is a cursor? : Sql dba

0 Answers  

---

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  

---

Can we rollback truncate?

0 Answers  

---

How to disable a trigger name update_salary?

0 Answers  

---

What are the types of join in sql?

0 Answers  

---

Is progress software supports to ( pl/sql )?

0 Answers  

---