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
How to create new tables with "create table" statements in ms sql server?
What is the difference between a function and a trigger?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What are the types of user defined functions in sql server?
How raid can influence database performance?
What is 3nf normalization form?
What is ddl and dml commands?
How to drop existing views from a database in ms sql server?
List the different types of collation sensitivities in sql server?
Can foreign key be deleted?
How can you insert values in multiple rows using one Insert statement?
How to optimize stored procedure optimization?
What does ss stand for sexually?
What is a result set object returned by mssql_query()?
How is sql server used?