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

Answer Posted / yalamanda

select top 100 percent * from table_name..

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we change the table name in sql?

935

How does postgresql compare to "nosql"?

1026

How can we debug in PL/SQL?

1126

What is sql injection vulnerability?

937

What is synonyms?

1049

How to use distinct and count in sql query? Explain

1010

What program will open a mdb file?

954

what is myisam? : Sql dba

1070

what is datawarehouse? : Sql dba

1005

How can triggers be used for the table auditing?

1065

Can we use update in sql function?

1052

Does sql backup shrink transaction log?

971

What is primary key and foreign key with example?

923

What is the max nvarchar size?

959

What is the basic structure of an sql?

1095