can anyone give me a sql query for the following table

create table student details in sql
sql queries
sql query for student database
how to write sql queries
create table sql
sql query examples from multiple tables
sql commands with syntax and examples
sql query to select a particular row from a table

I have a table named eprism_reports and the table is as follows

In this table when I am using the query

SELECT  * 
FROM eprism_dashboard.eprism_reports 
where CARRIER_NAME='QA_T_MOB'

I am getting the following Resultset

SO after getting the result set again I want to remove the duplicate TAG_NAME and in that duplicate TAG_NAME unique TAG_NAME should appear and RERUN should be max

Example: In the Resultset we are having Two tagnames duplicated name mytag I want a unique one with ReRUn should be MAX and Remaining ResultSet as usual.Please help me on this

The Expected Result Should be as follows:

id  CARRIER_NAME CLAIM_TYPE STATUS   DATE       TAG_NAME  RERUN
9   QA_T_MOB    Approved    Passed  2018-05-15  Theft       0
10  QA_T_MOB    Denied      Passed  2018-05-15  Denied      0
11  QA_T_MOB    In Review   Passed  2018-05-15  In Review   0
12  QA_T_MOB    Approved    Failed  2018-05-15  mytag       1

I would just use subquery with correlation approach :

select e.* 
from eprism_reports e
where CARRIER_NAME='QA_T_MOB' and
      id = (select id 
            from eprism_reports
            where TAG_NAME = e.TAG_NAME
            order by rerun DESC
            LIMIT 1);

You can also express this as:

select e.* 
from eprism_reports e
where CARRIER_NAME='QA_T_MOB' and
      RERUN = (select max(RERUN) from eprism_reports where TAG_NAME = e.TAG_NAME);

How to write a SQL-Query for the following table?, Here is one method: select t.* from table t where exists (select 1 from table Given the exact requirements that you gave to us, this will give the  The query that i have tried was wrong anyone can give me correct query? Ask Question Asked 3 years, 4 months ago. Select n random rows from SQL Server table. 892.

SELECT TAG_NAME, MAX(RERUN) 
FROM eprism_dashboard.eprism_reports 
where CARRIER_NAME='QA_T_MOB'
GROUP BY TAG_NAME

The Best SQL Examples, This is used to select the database containing the tables for your SQL statements: There are also options you can use to show data that is not a table column. The following example is similar, but it further specifies that if any of the Order By gives us a way to sort the result set by one or more of the  SQL - SELECT Query. The SQL SELECT statement is used to fetch the data from a database table which returns this data in the form of a result table. These result tables are called result-sets.

You can try a query like this => http://sqlfiddle.com/#!9/057184/1

Select Max(rerun) value for each tag group, then query you table by joining on rerun and tag column

SELECT t.*
FROM   eprism_reports t
JOIN   ( SELECT MAX(rerun) rerun
              , tag
         FROM   eprism_reports
         GROUP  BY tag ) t2
  ON( t.tag   = t2.tag
  AND t.rerun = t2.rerun ) 

An Introductory SQL Tutorial: How to Write Simple Queries, The option that you choose will depend on your product's backend, so check with your product team to make sure you select the correct one. Write SQL query for the following : Table : Purchase. Field DataType Size Constraints. CustID CHAR 5 Primary key CustName Varchar 30 ItemName Varchar 30 PurchaseDate Date Qty Int Rate Int Amount Int (v) To create above table as per specification given (vi) Add new column ‘ItemCategory’ to store one Characters only.

To get the highest rerun row per group you can do a self join

select a.* 
from eprism_reports a
left join eprism_reports b on a.CARRIER_NAME = b.CARRIER_NAME
                           and a.TAG_NAME = b.TAG_NAME 
                           and a.RERUN < b.RERUN
where a.CARRIER_NAME='QA_T_MOB' 
and b.CARRIER_NAME is null

42 Questions on SQL for all aspiring Data Scientists, This test will help you assess your skill on SQL. Create a table “Me” using the below SQL query. Query1: Create 33) Which one of the following queries always gives the same answer as the nested “Query” shown below. In no event shall Microsoft, its authors, or anyone else involved in the creation, production, or delivery of the scripts be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample scripts or documentation, even if Microsoft has been advised of the possibility of such damages.

41 Essential SQL Interview Questions and Answers, Whether you're a candidate or interviewer, these interview questions will help prepare you Given two tables created and populated as follows: the customer's name, and the name of the customer who referred that customer (if any). Dept table, how many rows will be displayed in the result of the following SQL query: Can Someone help me create these sql queries?(Database code is located beneith the questions) 3.1. Create SQL to update the address for a specific customer. Include a select statement before. and after the update. 3.2. Create SQL to increase the hourly rate by $2 for each worker that has been an employee for at. least 1 year.

Beginner SQL Tutorial: Learn SQL Basics While Analyzing Bike , Learn the basics of SQL and databases while analyzing a data set on bike If you'd like to follow along you can download the hubway.db file here (130 MB). This enables us to pull up all of the customer info for any given order, but we only This means the SELECT command has given us every column in the trips table​. SQL SELECT statement with NULL values Before storing a value in any field of a table, a NULL value can be stored; later that NULL value can be replaced with the desired value. When a field value is NULL it means that the database assigned nothing (not even a zero "0" or blank " " ), in that field for that row.

SQL SELECT Statement, Here, column1, column2, are the field names of the table you want to select data from. If you want to select all the fields available in the table, use the following 

Comments
  • Most people here want formatted text, not images.
  • Specify the expected result as well. (Formatted text...)
  • Okay Sure thanks
  • Thanks your answer Helped to get my output