select sal from emp group by sal
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / pankajsharma
it will fetch all the salaries one tme in case of duplicacy
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / arun karthick
select sal from emp group by sal; and select distinct sal
from emp ;
Both queries will give the same result - fetch the salary
in emp table without duplicates.
Is This Answer Correct ? | 1 Yes | 0 No |
what is mean by forward declaration and where we'll use it.
what is sql optimization
What is an invalid partition table?
Explain the uses of database trigger.
Explain correlated query work?
How do you explain an index number?
What is data control language (dcl)?
Write the order of precedence for validation of a column in a table ?
What is difference between select statement and cursor
how to get a list of all tables in a database? : Sql dba
How do I count rows in sql query?
What is sql and also describe types of sql statements?