select top 100 percent * from table

i have xml source. xml source having lacks of records. i
want extract/retrive xml source data using sql query.
please tell me how to write query.

Question Posted / yalamanda

4 Answers
8171 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / yalamanda

select top 100 percent * from table_name..

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 sql and db2?

958

What is the use of sqlerrd 3?

908

What is sql*loader and what is it used for? : aql loader

1116

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1005

Does normalization improve performance?

999

What is rank () in sql?

906

How do I save a stored procedure?

965

Can we call a function containing dml statements in a select query?

939

what is the difference between where clause and having clause? : Sql dba

966

When sql appeared?

1045

How do you update f as m and m as f from the below table testtable?

1810

How to Execute a Package in PL/SQL.?

1142

What are the benefits of pl sql?

1079

What are synonyms in sql?

945

How can I change database name in sql?

1023