Write query based upon item table given. Display students' info., who are getting average marks of more than 80 and scode 333.
Advertisements
Advertisements
प्रश्न
Write query based upon item table given.
Students
| Adno | Name | Average | Sex | Scode |
| 501 | R.Jain | 98 | M | 111 |
| 545 | Kavita | 73 | F | 333 |
| 705 | K.Rashika | 85 | F | 111 |
| 754 | Rahul Goel | 60 | M | 444 |
| 892 | Sahil Jain | 78 | M | 333 |
| 935 | Rohan Saini | 85 | M | 222 |
| 955 | Anjali | 64 | F | 444 |
| 983 | Sneha Aggarwal | 80 | F | 222 |
Display students' info., who are getting average marks of more than 80 and scode 333.
कोड लेखन
Advertisements
उत्तर
SELECT * FROM Students WHERE Average > 80 AND Scode = 333;shaalaa.com
या प्रश्नात किंवा उत्तरात काही त्रुटी आहे का?
पाठ 10: Structure Query Language - EXERCISE [पृष्ठ २००]
