open navigation menu
AiFolder
Tools for a smarter you
Discover
Tools
AI
Games
Interviews
Blog
More
Search AiFolder
Toggle theme
Toggle theme
Sign in
Exit
00:00
Submit test
SQL · Advanced
10 questions · Question 1 of 10
10%
Multiple Choice
Senior
How to generate row number in SQL without ROWNUM
A
With a Clustered index the rows are stored physically on the disk in the same order as the index.
B
UNION combines the results from 2 tables and eliminates duplicate records from the result set.
C
UNION removes duplicate records (where all columns in the results are the same), UNION ALL does not.
D
Consider: SELECT name, sal, (SELECT COUNT( ) FROM EMPLOYEE i WHERE o.name = i.name) row num FROM EMPLOYEE o order by row num
Previous
Next