Answer Posted / ashis dey
select top 100 fieldname from tablename group by fieldname
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
How to enter binary string literals in ms sql server?
Can we do dml on views?
How to connect php with different port numbers?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Why and when do stored procedure recompile?
What kind of problems occurs if we do not implement proper locking strategy?
Can one drop a column from a table?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Why use identity in sql server?
What is standby servers? Explain types of standby servers.
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What are the source of constraints?
What is a scheduled job or what is a scheduled task?
Can sql servers link to other servers like oracle?
What are the different types of subquery?
