Answer / suma

select distinct(emp_name) from employees;

Answer / os reddy

select distinct * from emp;

OR

select unique * from emp;

Answer / prasi

select distinct(names) from employees;

Answer / klkl

correct
select distinct(emp_name) from employees;

Answer / rakesh

select distinct * from emp;

Answer / dinesh kumar

select distinct * from table_name;

Answer / eshwer

by using min(rowid) or max(rowid). its like deleting duplicate values.

select columns from emp where rowid not in[in] (select maxrow(id) from emp group by columns);

How will you select unique values from a list of records?

7 Answers   Cap Gemini,

What is difference between sql and mysql?

0 Answers  

What is materialised View?

2 Answers   IBM,

suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary

7 Answers  

what is the bond code in materialized view?

0 Answers  

What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,

display null value rows with out using null function?

8 Answers   Infosys,

Types of optimization?

6 Answers   Microsoft,

when a procedure /package is getting invalidated?

4 Answers   TCS,

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

0 Answers  

What does 0 mean in sql?

0 Answers  

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

0 Answers