oracle - SQL find rows not having duplicate column values -

-

I have a query 

  select * from circuit where y = 'b';

I get the following results 

  x | Location_A | Place_b Y ----------------------------------------- 1232 | Mexico | USA B1232 | Mexico | USA B1232 | Brasil | USA B 99 99 Brasil | USA B

I need to know the x , which has no duplicated location_ and location_b. In this case the following data is printed.

1232 | Brasil | USA B 99 99 Brasil | USA B

I am using Oracle 10G Please let me know if this is possible. (Separate / group will remove duplicate, but still a line I do not need)

You can use the Analytical Function to calculate matches and then filter: 

  select x, location_a, location_b, y (select c. *, Count (* ) Over (x, location_a, location_b) circuit as cnt) c where cnt = 1;

Edit:

More section introduces an analytical function to actually understand them, you can see the documentation (see) Can start with. This special function specifies a value for each row in the result set. The value is the number of rows where the question of x , location_a , and location_b are the same value as the row for your data, it will be assigned: 

  x | Location_A | Place_b Y CNT ----------------------------------------------- 1232 | Mexico | USA B 2 1232 | Mexico | USA B 2 1232 | Brasil | USA B 99 99 Brasil | USA B 1

The first two lines have "2" because 1232 / Mexico / USA have two rows in one of the last two because they have three separate ones.


Comments

Post a Comment

Popular posts from this blog

Active Directory Authenticated Proxy Server with Squid or CNTLM -

-
I need to configure a proxy server for a local network that authenticates with Active Directory and gives me access The control list enables you to configure the domain groups within AD. I am using: Static with Squid 2.7: Windows 2008 Server R2 I have followed this guide here: The proxy does not currently ask for any Active Directory accounts, as soon as I add the following lines, it starts denying this connection: ACL localnet proxy_auth Required src 192.168. 0.0 / 24 http_access permission localname This is my squid.conf: pastebin.com/ERuKtirc I see logs and 'none' or 'direct' L It comes together TCP_DENIED message 1415014073.069 1 192.168.0.63 TCP_DENIED / 407/1904 Received / -. None / - Text / html 1415014073.07 9 4 192.168.0.63 TCP_DENIED / 407 2304 Received / - None / - Text / html 1415014073.084 2 192.168.0.63 TCPDAD / 407 1904 Received / - None - - Text / html itemprop = "text"> This proxy returns a 407 request with a browse...
Read more

java - @PluginTarget(Node.class) not registering as neo4j plugin -

-
Simple class below will not show as a plugin package com.danmacias neoneoteplugin ; Import java.util.ArrayList; Import java.util.list; Import org.neo4j.graphdb. *; Import org.neo4j.server.plugins *; Import org.neo4j.graphalgo *; // import org.neo4j.tooling.GlobalGraphOperations; @ Description (expansion of Neo4j server to achieve all nodes or relationships) Public class GetPaths expanded the server plugin {@ name ("breadth_first_paths") @ Description ("first wide travel traversal of specific node"). @plugin target (node ​​class) public shaky & lt; Path & gt; GetPaths (@ Source Node Graphidi) {ArrayList & lt; Path & gt; Path = new arreelist & lt; & Gt; (); Return path; }} curl return {"extension": {"GetAll": {"get_all_nodes": "http: // localhost: 7474 / db / ext / GetAll / graphdb / get_all_nodes "} ...}, But when I Node.class both conditions GraphDatabaseService I change with Class ,...
Read more

python - Calculate STD manually using Groupby Pandas DataFrame -

-
Image
I was trying to write a solution, which is a different and a manual for calculating a mean and STD The way. I have created a = ["Apple", "Banana", "Cherry", "Apple"] B = [3,4,7,3] C = [5,4,1,4] D = [7,8,3,7] Pd DF = PD to import pandals DataFrame (index = class (4), column = list ("ABCD")) DF ["A"] = A DF ["B"] = BDF ["C"] = C DF ["D"] = D Again, I made a list of A duplication. Then I went through the group all the time of the objects and calculated the solution. import as np l = list (set (df.A)) df.groupby ('A', As_index = False) listMean = [0] * len (df.C) ListSTD = [0] * L in the LAN (df.C) X: s = np.mean (df [df ['A'] == x] for C =.) = Z = [index for index, enumerate In the object (df ['a']. Value] x == item i for z: listMean [i] = s in: s = np.std (df [df ['a'] == X] .cvalues) z = index for index, enumerate item (df ['a']. Value) if x ==...
Read more