What will be the output of below query?

select * from employee_master;
go

select top 100 percent * from employee_master;

If employee_master is having 100 records;
go

Posted by vishalneeraj-24503 on 11/29/2013 | Category: Sql Server Interview questions | Views: 3487 | Points: 40

Answer:

Both query will give us the same record means 100 records will be displayed.
100 percent means total records.

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : What will be the output of below query? Select ...

Next > : What will be the output of below query? select ...

More Interview Questions by vishalneeraj-24503

Latest Interview Questions