Hi guys try this query If any student fails in one subject also his result should be Faile r else Pass condtion is(marks>=40 "PASS" marks

nancy

• Jul 19th, 2016

Code
SELECT Name,
when Min(Mark)>40
Then Pass
Else Fail
End
FROM TableName
GROUP BY Name

SOnali

• Jun 29th, 2016

Select Name,
when Min(Mark)>40
Then Pass
Else Fail
End
From TableName
Group By Name

Answer Question  Select Best Answer

S_NAME MARKS ramu 60 ramu 40 ramu 50 karan 30 karan 96 karan 46 out put: ramu "PASS" karan "FAIL"

Elangovan

• Aug 13th, 2015

Code
SELECT name, CASE WHEN min_marks < 40 THEN FAIL ELSE PASS END AS result FROM (
SELECT name, MIN(marks) AS min_marks FROM student GROUP BY name) a 

Ritesh Kumar

• Mar 24th, 2015

"sql WITH t1 AS (SELECT name, COUNT ( result ) as tt_sub_pass FROM student WHERE result >= 40 group by name ...

Answer Question  Select Best Answer

Please Give any scenario (Or) example of its very help full?

Somesh Menaria

 Profile Answers by Somesh Menaria Questions by Somesh Menaria

• Feb 22nd, 2016

It is used to improve quering performance

Arjun

• May 29th, 2015

Materialized view is an option when we have data coming on a regular fashion in slots like last weeks data that will be used this week and data is too huge to generate at any point of time this is jus...

Answer Question  Select Best Answer

If it reduce the traffic then please give an example for that one

Oracle Training in Chennai

• Mar 3rd, 2015

A materialized view, or snapshot as they were previously known, is a table segment whose contents are periodically refreshed based on a query, either against a local or remote table. Using materialize...

Ashish

• Feb 10th, 2015

Materialized views stores data init at the client side only so they do not need to fetch the records each time by hitting the database. They get the refresh only when executed manually or when set to get the refresh based on the settings. Therefore they are always faster than the normal views.

Answer Question  Select Best Answer

Delete duplicate records without using sub query? Is That possible

Aak

• Sep 15th, 2016

Use a temp table, store distinct rows. Either delete the old table and rename this new table with the old table name or truncate old table and insert rows from temp table to the old table.

kadari ashok

• Jul 14th, 2016

We can do through co-related sub query

Answer Question  Select Best Answer

When use Before and After Trigger? Please any help for this one

chaithanya

• Jul 1st, 2014

Before trigger is used while performing DML operations and whereas After Trigger is used for after performing DML operations Real time Example for before trigger: in banking systems: ...

Mrutyunjay Nayak

• Jul 1st, 2014

Before Trigger is used only when u want to restrict the invalid data entry in a table.After trigger is used when u perform the operation in one table that will effect on other table.

Answer Question  Select Best Answer

Procedure also written the values using out parameter than why we need functions?

Rakesh057

 Profile Answers by Rakesh057 Questions by Rakesh057

• Jul 1st, 2014

Because procedure is pre compiler and function is not pre compiler so that the reason we go for an calculation part in function

Madhav

• Jul 1st, 2014

Procedure also written in out parameter but we can not use procedure in Sql statement.

But if we wrote function and ita cant contain DML operation then we can access this function in SQL queries.

Answer Question  Select Best Answer