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
Is it possible to create startup or shutdown trigger for on-schema?
What is pivot query?
What is a database trigger?
Can we use ddl statements in stored procedure?
What is a primary key example?
Which is better trigger or stored procedure?
What is a sql*loader control file?
What port does sql server use?
What if we write return in procedure?
What are the disadvantages of not performing database normalization?
Why indexing is needed?
What is the use of & in pl sql?
How can you tell the difference between an index and a view?
Can we use ddl commands in pl sql?
What schema means?
