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 many triggers are allowed in mysql table? : Sql dba
What is primary key and unique key?
How does sql profiler work?
Why use stored procedures?
Which language is used in sql?
What is difference between nchar and nvarchar?
what is 'mysqlshow'? : Sql dba
When are we going to use truncate and delete?
How do you pronounce sql?
What is varchar example?
Which normal form is best?
What is the function that is used to transfer a pl/sql table log to a database table?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
What are the constraints available in sql?
What is a natural join sql?
