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 package in pl sql with an examples?
What is a string data type in sql?
How do you know if a relationship is 2nf?
What is pragma in pl sql?
Can procedure in package be overloaded?
What are the two parts of design view?
Explain ddl statements in pl/sql?
What are the different types of tables in sql?
Explain select statements in sql?
What is embedded sql in db2?
How sql query is executed?
What is sql injection owasp?
Is drop table faster than truncate?
What is the maximum number of rows in sql table?
What is the file extension for sql database?
