sql

[Solved] Convert SQL WHERE query to JOIN [closed]

by

For the most part, you just change your comma separated tables to JOIN clauses. The “ON” clause of the join is what comes from the WHERE clause SELECT DISTINCT r.recipe_id, r.recipe_name, r.recipe_image, r.recipe_duration, r.recipe_serving, r.recipe_difficulty, (SELECT category_name FROM tbl_category WHERE r.category_id = category_id) AS category_name, (SELECT cuisine_name FROM tbl_cuisine WHERE r.cuisine_id = cuisine_id) AS cuisine_name, … Read more

[Solved] SQL Procedure Removing System Privledges [closed]

by

You are missing IN in the FOR statement; it should be: FOR rec IN (SELECT privilege, admin_option FROM dba_sys_privs WHERE grantee = l_username) LOOP See http://docs.oracle.com/cd/E11882_01/appdev.112/e17126/static.htm#CIHCGJAD 2 solved SQL Procedure Removing System Privledges [closed]

[Solved] Can some expert please explain what this query is doing? [duplicate]

by

ROW_NUMBER in a subquery combined with a filter on it in the outer query is an idiom to filter out all but the first row in a group. So here ROW_NUMBER() OVER(PARTITION BY [dbo].[RegistrationHistory].[SerialNumber]) Assigns the row with the lowest SerialNumber 1, the next lowest, 2, etc. Then later where t.seq = 1 removes all … Read more

[Solved] What does * mean in sql?

by

I am providing you answer by seperating each part of code. SELECT == It orders the computer to include or select each content from the database name(table ) . (*) == means all {till here code means include all from the database.} FROM == It refers from where we have to select the data. example_table … Read more

[Solved] Updating a column based on values from other rows [closed]

by

Following your edit… DECLARE @T TABLE ( ID INT, CategoryID CHAR(4), Code CHAR(4), Status CHAR(4) NULL ) INSERT INTO @T (ID,CategoryID, Code) SELECT 1,’A100′,0012 UNION ALL SELECT 2,’A100′,0012 UNION ALL SELECT 3,’A100′,0055 UNION ALL SELECT 4,’A100′,0012 UNION ALL SELECT 5,’B201′,1116 UNION ALL SELECT 6,’B201′,1116 UNION ALL SELECT 7,’B201′,1121 UNION ALL SELECT 8,’B201′,1024; WITH T AS … Read more

[Solved] Sql Select From multiple table [closed]

by

You should write as: — STEP2: Insert records: INSERT INTO @Travels SELECT CountryId,VisitorId,0 FROM — 0 = false for IsVisited ( — STEP1: first create a combination for all visitor Id and country Id — and get all the combinations which are not there in existing Travels table SELECT C.CountryId,V.VisitorId FROM @Country C CROSS JOIN … Read more

[Solved] How to write a query, to produce the desired result?

by

You can use DENSE_RANK(). For example: select id, name, quantity from ( select id, name, quantity, dense_rank() over(order by quantity desc) as rk from t ) x where rk <= 2 DENSE_RANK() computes a number for each row according to an ordering of your choosing. Identical values get the same number, and no numbers are … Read more

[Solved] How to Remove Duplicates Values from table [duplicate]

by

Since your screenshot is of phpMyAdmin, I’m going to assume that we’re talking about MySQL here (when asking questions, that’s helpful information as various SQL dialects have different tools that can be used). If you don’t need id in your results, you can just use DISTINCT: SELECT DISTINCT Username, Video FROM YourTableName This returns a … Read more