select sal from emp group by sal
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 14 Yes | 3 No |
Answer / pankajsharma
it will fetch all the salaries one tme in case of duplicacy
| Is This Answer Correct ? | 3 Yes | 1 No |
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 This Answer Correct ? | 1 Yes | 0 No |
What is the order of sql select?
Is it possible to read/write files to-and-from PL/SQL?
What is union?
What is the difference between left join and right join?
What is materialized view. What are different methods of refresh?
1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....
How can I speed up sql query?
What is oracle sql developer?
What is mutating trigger?How to avoid it??
what is union? : Sql dba
Explain the components of sql?
What is the difference between microsoft access and sql?
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)