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.

Is sql a backend language?

0 Answers  

---

when MSQL8.0 is in market

0 Answers  

---

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance

5 Answers   Target,

---

What are the types of subqueries?

0 Answers  

---

What is a CTE (Common Table Expression), and how is it different from a subquery?

3 Answers  

---

What is the maximum number of columns in sql table?

0 Answers  

---

What is meant by temporal data?

0 Answers  

---

using subquery how can i calculate working days in a month?

3 Answers   Spice Telecom,

---

what is the output of this query selet * from employee where 1=2 ??

11 Answers  

---

types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.

4 Answers   3i Infotech,

---

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

---

What is the difference between the Primary and Foreign key?

7 Answers   Cap Gemini,

---