I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answer Posted / mohammed mujahid
select MAX (EmployeeSalary) from EmployeeDetails where
EmployeeSalary in (select MAX(EmployeeSalary) from
EmployeeDetails)
Here I have changed the table name and column name plz
check it ones with student details
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are sql server procedures?
What are exact numeric data types in ms sql server?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
how we use window authentication connection with sql server.?
How to trouble shoot if unable to connect SQL Server
how can a database be repaired? : Sql server administration
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
How can sql injection be stopped? : sql server security
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
Explain how dts is used to extract, transform and consolidate data?
Explain difference between cross join and full outer join?
What are the advantages of sql stored procedure?
Tell me can we use custom code in ssrs?
What is the difference between varchar and varchar(max) datatypes?
What is inline variable assignment?