select sal from emp group by sal

Answer Posted / pankajsharma

it will fetch all the salaries one tme in case of duplicacy

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by <> in sql?

503


What is on delete set null?

563


What do you mean by dbms? What are its different types?

552


what is a table in a database ? : Sql dba

540


How do you use join?

524






Explain the difference between 'between' & 'and' operators in sql

526


What is the difference between view and stored procedure?

490


How do you remove duplicates without using distinct in sql?

499


how to fetch alternate records from a table? : Sql dba

592


Can sql developer connect to db2?

584


Can we have two clustered index on a table?

562


How to sort the rows in sql.

600


What is compilation error in pl sql?

504


How to combine two stored procedures in sql?

591


Why do we use procedures in pl sql?

518