Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between a primary key and a clustered index?
What is difference sql and mysql?
What is the best free sql database?
what is the difference between delete and truncate commands? : Sql dba
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What are crud methods?
What is database white box testing and black box testing?
What is sql table?
Does a primary key have to be a number?
What is write ahead logging in sql server?
What jobs use sql?
What is the difference between syntax error and runtime error?
What does trigger mean in psychology?
Mention what pl/sql package consists of?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
