Display a roll having miminum marks in two subjects?

Answer Posted / jiten patel

Select * from (table name)where (field1)=(select
min(field1)from
table name) and (field2)=(select min(field2) from table name)

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can sql server instances be hidden?

690


What are approximate numeric data types in ms sql server?

758


What is difference between equi join and natural join?

710


What is difference between view and materialized view?

701


Can we use pragma autonomous_transaction in trigger?

704






List the different index configurations possible for a table?

680


what are cursors? : Sql server database administration

719


What are the advantages of the mirroring?

778


Which data type columns are the best candidates for full-text indexing?

755


What are data resources?

664


What is a View ? Can we insert, Update and delete a view?

788


When would you use it?

759


Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

808


Explain what is raid and what are different types of raid levels?

709


What is built-in function?

704