What is the bookmark lookup and rid lookup?
No Answer is Posted For this Question
Be the First to Post Answer
Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?
What are binary string data types in ms sql server?
How do I trace a query in sql server?
Mention the different types of replication in sql server.
What is self contained sub query?
What are the disadvantages of using the stored procedures?
Do you know concepts and capabilities of sql server?
What is self join in sql server joins?
How do I create a trace in sql server?
What about UPDATESTATISTICS ?
What happens when transaction log is full?
How the authentication mode can be changed?