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 replication id?
What is difference between inner join and self join?
How many types of functions are there in sql?
What is sql rowcount?
What does select count (*) mean in sql?
what is a database? : Sql dba
What if we write return in procedure?
How can we make an if statement within a select statement?
What is a dirty read sql?
Who is the owner of mysql database?
Can pl sql procedure have a return statement?
what is a record in a database ? : Sql dba
Can instead of triggers be used to fire once for each statement on a view?
What are different types of statements supported by sql?
Does inner join remove duplicates?
