How to select two queries result simultaneoulsly
-
I have a table named Tresult, i have detail description of all the schools as mentioned below:
Stu_Name School_name Tot_mrks Top_state
Note: No field is primary key and i can't modify the structure of it.
i want to fetch details of top 5 states from the entire country based on their (totl_marks) and simultaneously top 2 schools for each topped state
same table as mentioned below
Stu_Name School Tot_marks Top_state
John BPS 500 DEL
Peter HSS 499 DEL
Rose BVB 498 CHN
Martin CMV 499 CHN
Raju SXR 500 MUM
Chris NVS 450 MUM
Abrah MPS 435 RAJ
Daisy RJS 415 RAJ
Tom VNS 415 KAN
David FPA 400 KAN
Pls. help me as i am not getting data in this structure.
Kindest Regards,Neetu Sharma
-
This was removed by the editor as SPAM
-
sir, may i know what the name of your database? and what type of database you use? is it access 200 or sql server? because in sql serever there is no queries , only store procedure has been made used or a calling parameter... please response
-
Who say's SQl does not contain queries, as the name suggest SQL-Structured Query Language.
This language is for querying.
Kindest Regards,Neetu Sharma
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply