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
Explain correlated query work?
What is cte sql?
Explain the difference between rename and alias?
What is a table?
Why we use joins in sql?
What are the three forms of normalization?
What is mutating sql table?
Can we call dml statement in function?
What is the need of merge statement?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
Can we insert in view in sql?
What is the difference between rollback and rollback to statements?
State some properties of relational databases?
Why do we need databases?
What is the primary use of normalization?
