Answer Posted / thanjairajan@gmail.com
select * from emp a where 2=(select count(distinct(b.rowid)) from emp b where a.rowid>=b.rowid;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the operators used in select statements?
Does a primary key have to be a number?
What is the non-clustered index in sql?
Can we change the table name in sql?
What is the purpose of normalization?
Is ms sql traffic encrypted?
What does 0 mean in sql?
What is indexing oracle sql?
How do I view a sql trace file?
how can we submit a form without a submit button? : Sql dba
What is relationship? How many types of relationship are there?
What is the least restrictive isolation level? : Transact sql
what is self join and what is the requirement of self join? : Sql dba
what is the difference between cluster and non cluster index? : Sql dba
which operator is used in query for pattern matching? : Sql dba