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

How does one load ebcdic data? : aql loader

654

Which constraints we can use while creating database in sql?

619

Is vs as in pl sql?

494

What is the difference between view and stored procedure?

496

Differentiate between % rowtype and type record.

735

What does pl sql developer do?

510

What sql database should I use?

553

What is right join sql?

536

what is bcp? When does it used? : Sql dba

526

Explian rowid, rownum?

564

What is use of package in pl sql?

534

What is a temporal table?

497

Why do we need cursor in pl sql?

651

Can you call pl/sql package functions from within a fast formula?

564

how to create a test table in your mysql server? : Sql dba

498