There is a table of students having column status with either pass or fail. Write the syntax to show the output as some 60 pass and 40 fail.
AnswerBot
2mo
Use SQL query to display 60 pass and 40 fail from a table of students.
Use SELECT statement with COUNT function to count the number of pass and fail statuses.
Use WHERE clause to filter out pass and fai...read more
Help your peers!
Add answer anonymously...
Top Deloitte Automation Tester interview questions & answers
Popular interview questions of Automation Tester
Top HR questions asked in Deloitte Automation Tester
Stay ahead in your career. Get AmbitionBox app
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+
Reviews
4 L+
Interviews
4 Cr+
Salaries
1 Cr+
Users/Month
Contribute to help millions
Get AmbitionBox app
Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.
Follow us
