Suppose a Student column has two columns, Name and Marks. How to get names and marks of the top three students.

Question

Suppose a Student column has two columns, Name and Marks. How to get names and marks of the top three students.

1 Answer

Related questions

0 votes

Q: How to write a query to show the details of a student from Students table whose name start with K?

asked Jul 7, 2020 in Sql by Robindeniel

0 votes

Q: A Rails project has ActiveRecord classes defined for Classroom and Student. If instances of these classes are related so that students are assigned the ID of one particular classroom

asked Aug 26, 2022 in Ruby by Robin

0 votes

Q: How to write an SQL query to find students' names start with 'A'?

asked Nov 8, 2021 in Sql by rajeshsharma

0 votes

Q: If a student gains unauthorized access to the student database and modifies his/her marks, what type of violation would it be?

asked Apr 2, 2022 in Cybersecurity Prologue by sharadyadav1986

+1 vote

Q: How do we get the complete list of columns that exist in a column Family in HBase?

asked Jun 13, 2020 in HBase by Robindeniel

+1 vote

Q: How to select columns in pandas and add them to a new dataframe? What if there are two columns with the same name?

asked Feb 14, 2021 in Python by SakshiSharma

0 votes

Q: How to Fix SQL Server: Invalid Column Name

asked Feb 2, 2021 in Sql by SakshiSharma

+1 vote

Q: The Scrum Master wants to establish a team's initial velocity. A team has two testers, three developers, one full-time Scrum Master, and a Product Owner split between two teams.

asked Dec 26, 2019 in Agile by srikanth

+4 votes

Q: The Scrum Master wants to establish a team's initial velocity using normalization. A team has two testers, three developers, one full-time Scrum Master, and a Product Owner split between two teams.

asked Jul 31, 2019 in Agile by sheetalkhandelwal

+2 votes

Q: he Scrum Master wants to establish a team's initial velocity using normalization. A team has two testers, three developers, one full-time Scrum Master, and a Product Owner split between two teams.

asked Jun 17, 2019 in Agile by tempuser123

0 votes

Q: A team has two testers, three developers, one full-time Scrum Master, and a Product Owner split between two teams. What is their normalized velocity before calculating for time off?

asked Nov 7, 2019 in Agile by sachatouille

+1 vote

Q: How to delete a column or group of columns in pandas? Given the below dataframe drop column “col1”.

asked Feb 14, 2021 in Python by SakshiSharma

+1 vote

Q: How to create a new column in pandas by using values from other columns?

asked Feb 14, 2021 in Python by SakshiSharma

0 votes

Q: Which function(s) of dplyr would you use to first subset the columns and then sort them on a particular column?

asked May 27, 2019 in Other by tempuser

0 votes

Q: Which function do you use to print the names of all columns in a data frame?

asked Jun 6, 2019 in Data Handling using R by tempuser

0 votes

Q: Suppose you need to collect and print data from IMDb top 250 Movies page.

asked Oct 12, 2021 in Python by rajeshsharma

0 votes

Q: Which of the following attributes or arguments are used to set column names of a data frame?

asked Aug 13, 2021 in Python Pandas by SakshiSharma

0 votes

Q: Name three disadvantages Hbase has as compared to RDBMSin HBase?

asked Jun 10, 2020 in HBase by Robindeniel

0 votes

Q: What is the Query in SQL to Get Month Name

asked Jan 7, 2021 in Sql by SakshiSharma

+2 votes

Q: How can you capture the length of a column when it is a Text, NText and/or Image data type?

asked Jan 14, 2022 in Sql by GeorgeBell

sharadyadav1986 · Answer 1 · 2020-07-10T11:07:22+0000

SELECT Name, Marks FROM Student s1 where 3 <= (SELECT COUNT(*) FROM Students s2 WHERE s1.marks = s2.marks)

Suppose a Student column has two columns, Name and Marks. How to get names and marks of the top three students.

1 Answer

Related questions

HOT LINKS

TRANDING TECHNOLOGIES

CONTACT US

Follow us on Social Media