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 rollback truncate?

1007

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

986

What are crud methods?

1043

What is localdb mssqllocaldb?

1073

What is acid property in a database?

1041

Can a primary key be a foreign key?

1031

How many types of tables are there?

958

How many sql are there?

1008

How to order siblings in oracle hierarchy queries?

1054

How to write pl sql program in mysql command prompt?

1104

Is primary key clustered or nonclustered?

1027

How to make a copy values from one column to another in sql?

1044

Difference between table function and pipelined function?

1030

What is sql server and ase?

1035

What is a stored procedure in sql with example?

1139