How will you select unique values from a list of records?
Answer Posted / os reddy
select distinct * from emp;
OR
select unique * from emp;
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
what is 'mysqlcheck'? : Sql dba
What is auto increment feature in sql?
What is the usage of when clause in trigger?
what is the difference between join and union? : Sql dba
Is grant a ddl statement?
Does sql use python?
Which join is default?
Why are sql stored procedures used?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
What is full join in sql?
Why is sql important?
what are aggregate and scalar functions? : Sql dba
How do I view a sql trace file?
What are actual parameters and formal parameters?
Which is better join or inner query?