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
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
Is sql procedural language?
What is the difference between unique and primary key constraints?
What is sqlite used for?
Which is faster view or stored procedure?
What are two statement types in sql?
Write a query to find the names of users that begin with "um" in sql?
What are all different types of collation sensitivity?
What is cost in sql execution plan?
List different type of expressions with the example.
What is query optimization in sql?
how would you get the current date in mysql? : Sql dba
what is a view? : Sql dba
Explain the the delete statements in sql?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
