Member Avatar for sanjay@srvmedia

id name class marks

1 H 1 60
2 H 2 50
3 S 1 70
4 S 2 60
5 V 1 55
6 V 2 80
7 K 1 60
8 K 2 70

This is my table structure.
I want mysql query to get result like

id name class marks

1 S 1 70
2 S 2 60

  • 2 Contributors
  • 1 Reply
  • 298 Views
  • 2 Minutes Discussion Span
  • Latest Post Latest Post by jj.dcruz
Member Avatar for jj.dcruz

do you have distinct values? so it can be call easier like status.
mysql query would be like this

SELECT `id`,`name`,`class`,`marks` FROM tbl_name WHERE name='S'
Edited by jj.dcruz
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.