How will you select unique values from a list of records?
Answer Posted / prasi
select distinct(names) from employees;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what is the syntax for using sql_variant_property? : Transact sql
Explain select statements in sql?
Does varchar need length?
Can you join views in sql?
Can a select statement fire a trigger?
What are the types of index in sql?
What is not equal in sql?
Explain unique key in sql.
What is procedure and function?
what is a relationship and what are they? : Sql dba
Is natural join and inner join same?
What is keys and its types?
Can you skip header records while loading? : aql loader
Which is faster joins or subqueries?
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