Query to fetch first 10 rows in DB2
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- There are 10 rows in Table A and 0 Rows in table B. Select * from A,B How many rows will be retrieved.
- How many rows will the following SQL return : "Select * from emp Where rownum = 10" ?
- How would you find out the total number of rows in a DB2 table?
- There are 10 rows in Table A and 0 Rows in table B. If you fire the following query:
- Emp table has 10 rows. How many rows will be fetched against the following query? Select 10 from emp where ...
- How many times pre query and post query fired when we fetch 10 record from a table ?
- Options to sort in DB2
- A table T1 having 100 rows is joined with a table T2 with 50 rows without specifying the joined column in t...