Answer / b.bathakaraithangam,giri

select * from student where mark=(select max(mark) from
student where mark not in (select max(mark) from student))

Answer / adarsh pandey

select distinct mark from student_mark s
where (select count(distinct s1.mark) from student_mark s1
where s1.mark>=s.mark )=4;

Answer / shrikant

I have student marks in a student table. I need all record
where second highest mark .Then what will the query for this?

Answer / rias

Select MIN(MARK) from student where mark in (select Top 2
mark from student order by mark desc)

Answer / sadaq moulani

select top 1 marks from student where marks in(select
distinct top 2 marks from student order by marks desc)

Answer / 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

Answer / rajat kumar

select top 1 marks from student where marks <(select max(marks) from student) order by marks desc

Answer / kunal sain

select mark from student s
where 1=(select count(*) from student s1
where s1.mark<s.mark);

Answer / sanah

select top 1 marks from marks where marks
<(select max(marks) from marks) order by 1 desc

Answer / abhishek srivastava

select top 1 marks from (select top 2 distinct marks from
students order by marks desc)
order by marks

Can you please explain the difference between function and stored procedure?

0 Answers  

statement (of account) Receive ID_receive Date_receive Amount_receive TO_receive From_receive Description_receive 1 2010/01/01 500 Bank Ahmed Payment from the account 2 2010/02/01 700 Bank Ahmed Payment from the account Payment ID_payment Date_payment Amount_payment From_payment To_payment Description_payment 1 2010/03/01 1000 Ahmed Sales Sale goods 2 2010/04/01 1500 Ahmed Sales Sale goods How can crate Stored Procedures for the statement (of account) from these tables? I want statement (of account) like this: (in sql 2005) ID_ name description debit account credit account balance

1 Answers  

what is difference between primary key and Unique

8 Answers  

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

0 Answers  

How to call a function from a stored procedure in SQL Server ?

0 Answers   HCL,

How to change the data type of an existing column with "alter table" statements in ms sql server?

0 Answers  

What are policy management terms?

0 Answers  

How can windows applications connect to sql servers via odbc?

0 Answers  

What is cdc in sql server?

0 Answers  

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

How to create a new schema in a database?

0 Answers  

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

0 Answers