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...

sql query to get zero records from a table

Answer Posted / vawani sankar naik

SELECT * FROM TABLE WHERE 1=2;

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a Nested Loop join?

2089


How to convert csv to table in oracle?

974


How to get execution statistics reports on query statements?

1064


Explain the use of analyse option in exp command.

1110


What is materialized view in Oracle?

1060


Explain the use of consistent option in exp command.

1041


Where do we use decode and case statements?

988


What is the difference between view and materialized view in Oracle?

1126


I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1089


If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2139


What is the difference between truncate & delete command?

1164


How to retrieve data from an explicit cursor?

1039


How to delete multiple rows from a table in oracle?

1050


Why oracle is used?

1034


How to view the tablespaces in the current database?

960