I’m trying to do electronic grade book in Java. I want to insert values of Marks and Description into rows But when I try to add Description to row, it looks like this: Is there any way I can also add description to the 3rd row? I tried many solutions and any of the solution I tried didn’t work. A…
Tag: mysql
Add Column in a table [closed]
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. This question does not appear to be about programming within the scope defined in the help center. Closed last year. Improve this question Am trying to add a column in the table salesperson. And it is showing…
How to show multiple tables list in MySql
How to show multiple table list in mysql I have a query that has two tables one for patients and the second one for patients who has tested for covid-19 I want to show all the patients either they tested or not If tested then show the result with his/her name It only showing the patients who has tested for
How do I query SQL for the latest record based on latest Date and Time OR Date_Time columns?
Situation: SerialNumber has duplicate rows and I need to select the latest records and get what is the Status value (either it PASS or FAIL does not matter). SerialNumber must be check based on the previous StationNumber. Example: I want to get the Status value of the latest record SerialNumber 19760123451234…
MySQL database re-orders entries automatically
I have created a MySQL database using MySQL Workbench. In there, I have created a table, the first entries of which are: id firstName lastName 1 John Smith 2 Emma …
SQL left join is not including all records from left table
I have a requirement to get monthly total hours worked on different tasks for each employee. For that purpose I am writing a stored procedure. But left join is not populating all record from employee table. I know somehow the where condition is filtering out the null values but I really don’t know how t…
how to get multiple columns from subquery inseide sql statement mysql
actually, I found many solutions for my issue but I didn’t understand how to apply to my issue! my issue is I have the following SQL statement: what I need is to replace the following part in one part: to get the all columns in one subquery with the same conditions? Answer I don’t know your data s…
Using CAST in MYSQL Query, It works in localhost, But in the server not working
In mysql using cast, I wrote the query like Accnno – varchar SELECT * FROM books where category = ‘Book’ ORDER BY CAST(Accnno AS int) DESC LIMIT 0,10 The above query is working fine in the localhost, But is not working in the server, It shows error like You have an error in your SQL syntax; …
Finding Cumulative progress with SQL
I have a SQL table as below : I need to calculate the cumulative progress. for example S1000 have three f1 score. the progress calculation formula is (95 – 87) + (87 – 80) for S2000 the calculation would be (75 -17) + (17 -57) How to achieve this using SQL Answer It looks like your progress score …
How to select data using like with out consider after character in laravel or sql
I have a table call labels_table. id label 1 A_1_1 2 A_1_2 3 A_2_1 4 A_4_1 5 A_10_1 6 A_11_1 I need to select all the labels for A_1 group. A_1_1 and A_1_2 should be the correct labels. I used the following query. sql Larval But both SQL and laravel queries returns all A_1_1, A_1_2, A_10_1 and A_11_1. But I