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 are the different types of a subquery?
How do I find duplicates in two columns?
What is meant by truncate in sql?
What is column?
Is it possible to read/write files to-and-from PL/SQL?
What is bulk compiling in pl/sql.?
What is an invalid partition table?
What is dml and ddl?
Mention what is the plv (pl/vision) package offers?
What is interval partition?
What are sql triggers used for?
Can variables be used in sql statements?
What are the uses of sysdate and user keywords?
How do you get column names only for a table (sql server)?
How to write a query to show the details of a student from students table whose
