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
How do I remove all records from a table?
how do you know if your mysql server is alive? : Sql dba
Why cross join is used?
what is the difference between blob and text? : Sql dba
Can a table contain multiple primary key’s?
What is plpgsql language?
How do you create a db file?
How do I run sql?
how to check myisam tables for errors? : Sql dba
Cite the differences between execution of triggers and stored procedures?
How do we accept inputs from user during runtime?
What is the difference between inner join and outer join?
What is java sql driver?
describe transaction-safe table types in mysql : sql dba
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.