To find second largest salary in Employee table

Answer Posted / padmapriya

Thanks every one who replied for my question.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is model database in sql server?

578


1 01 101 01010

1576


How do I find my localdb version?

504


Why I am getting this error when dropping a database in ms sql server?

602


Explain ms sql server reporting services vs crystal reports?

509






What is the guest user account in sql server? What login is it mapped to it? : sql server security

592


What does it mean to normalize data?

525


How many full-text indexes can a table have?

565


What is server-level principal?

102


Do you know hot add cpu in sql server 2008?

544


What is difference between sql and sql server?

552


In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

1561


What happens when transaction log is full?

515


What is blocking?

574


What stored by the tempdb ? : sql server database administration

575