how to retrive only second row from table?

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


Please Help Members By Posting Answers For Below Questions

What is the most restrictive isolation level? : Transact sql

576


What does select * from mean in sql?

2024


How can use stored procedures in sql?

595


Which tcp/ip port does sql server run?

542


how to drop an existing table in mysql? : Sql dba

567






Why do we use joins in sql?

512


what is a composite key ? : Sql dba

616


What is delimiter sql?

554


What is trigger and types?

578


Explain the the delete statements in sql?

585


What is a mutating table and a constraining table?

580


What is the use of function in sql?

551


How can you save or place your msg in a table?

530


What does sign mean sql?

584


what is sql profiler? : Sql dba

601