Tag: database

MySQL get rows starting with specific id after sort / order by

I got this table: I need to order it by score desc: and get first 3 rows which starts with id 6 So the result should be: Is this possible? Thanks in advance Answer With this: See the demo. Results:

is there anyway to display single column data into multiple columns

database mysql pivot sql sum

I tried to do it but it was impossible for me. the solution I need to display single column data into multiple column for the current table only. e.g column [status] 3 records {present,late,absent} to display 3 columns and single row, to prevent 3 rows The result i want to display like this by grouping tid Table structure Answer You

Locating unique column values and use the output for the next query

database ruby-on-rails sql

Rails 6.0.0 ruby-2.6.2 Hello I have a model called “Group” which connects to an SQLite database. This database has two columns I’m interested in, they are hits, as an integer and iteration as an …

Merge statement giving error on oracle when trying to merge two tables

database oracle oracle11g sql

i have a student table as : I have a stud_claim table as is : student_id is the foreign key of student table. At stud_claim table, I have paid_date column .paid_date has some data and some row is null.I need to update stu_claim table where paid_date is null and put the value of the service_date in that paid_date,if paid_date is

Select duplicated values from one coloum and get there value in one row

database duplicates mysql sql

i have table with 2 columns like below I want to select all values from table but view it like below: Answer If you’re not trying to create extra columns in your output, you can simply use GROUP_CONCAT with the separator of your choice. For example: Output: Demo on dbfiddle

Unknown column in field list when use join MySQL

database join mysql sql

I have 2 tables like this: product_master: campaign_product: This tables link with foreign key product_id I want to get all product data with campaign_code column. I don’t want to get 2 campaign_product row with same product_id. So I use this query: It got error when I run: Error in query (1054): Unknown column ‘dmspro_mys_campaign_product.campaign_code’ in ‘field list’ How I can