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
What is unpivot?
What are secondary xml indexes?
How to rename an existing column with sql server management studio?
How many types of subqueries are there in sql server?
How you can minimize the deadlock situation?
What is bcp? When does it use?
Explain what stored procedure sp_replcounters is used for? : sql server replication
How to add additional conditions in SQL?
List the various tools available for performance tuning?
how many type of indexing in database?
What is the difference between sdf and mdf?
How to start and end transact-sql statements?
Explain the dirty pages?
How do I view a stored procedure in sql server?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions