Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 are tables in sql?

1071


What are the query optimization techniques?

941


What is composite data type in pl sql?

1120


What is crud stand for?

1003


What schema means?

893


What are its different types of dbms?

1010


what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1132


Is clustered index a primary key?

951


How to handle bulk data?

1318


difference between anonymous blocks and sub-programs.

1139


What is the difference between cross join and natural join?

1028


What is difference between hql and sql?

1085


Do we need commit after truncate?

1087


What is recursive stored procedure?

1103


What do you understand by pl/sql records?

1024