Hardik Doshi Commented 12 Months ago through
Interview Questions | 1 Point
Nirav, I also agree with Nakul - Answer is not accurate. SELECT * returns the entire resultset/data for the tables used in the query.
We also need to check Schema name.
So, query should be:
SELECT os.name, ob.name, ind.rowcnt
FROM sys.s...