How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
Answer Posted / prafulla borade
SELECT MAX(VCRG_ID) FROM dbo.TRN_VEHICLE_CARGO WHERE VCRG_ID< (SELECT MAX (VCRG_ID) FROM dbo.TRN_VEHICLE_CARGO)
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
How would you choose between a clustered and a non-clustered index?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
What is the partitioning method?
Does hive support indexing?
Differentiate sql server reporting services vs. Crystal reports?
Can we take the full database backup in log shipping?
Give an example of why you would want to denormalize a database
how many clustered indexes can be created on a table? : Sql server database administration
What happens when unicode strings concatenate with non-unicode strings?
How to replace given values with null using nullif()?
Tell me what is difference between clustered and non clustered index?
How to configure odbc dsn with different port numbers?
What is difference statement and preparedstatement?
What are the differences between substr and charindex in sql server.