Interested to Buy Any Domain ? << Click Here >> for more details...
I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 69879 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
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 is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What is a cube? : sql server analysis services, ssas
What is onf in normalization form?
Explain what is dbcc?
What is a performance monitor?
Write a sql query to get zero records from a table having n number of records?
What is the difference between an index and a unique index?
Where are SQL server users names and passwords are stored in sql server?
How many types of keys are there?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What command do we use to rename a database?
How to create an identity column?
how can you check the level of fragmentation on a table? : Sql server administration
