Sharada ananya
two select queries shouldn't depend on each other
0 Answer(s)      4 years and 10 months ago
Posted in : SQL

i want to write two select queries such that both queries shouldn't depends on each other .or how can i re-write this query? can i write this without using where, where in, where exist? or can i use AND to this query?

     SELECT link_id, COUNT(*)  FROM Locator  GROUP BY linkid

     (SELECT show,actuate from Sem join class on

      Sem.semid = class.semid join Locator on linker.linkid=Locator.linkid);

Ads

View Answers









Related Tutorials/Questions & Answers:
two select queries shouldn't depend on each other
two select queries shouldn't depend on each other   i want to write two select queries such that both queries shouldn't depends on each other..., where in, where exist? or can i use AND to this query? SELECT link_id, COUNT
Hi, I'm new to JSP I want to create 3 dropdown list each depend on the other and get the options from the database using JSP
Hi, I'm new to JSP I want to create 3 dropdown list each depend on the other and get the options from the database using JSP  as i said i want to create 3 drop dropdown list each depend on the other and get the options from
Advertisements
Struts 1.2.9 (NB6.1) ? Problems with depend <html:select> and AJAX - Struts
Struts 1.2.9 (NB6.1) ? Problems with depend and AJAX  Hi I have 2 and one is depend to the other The 1st select I fill it of the DB... select value as a parameter How I do it with AJAX?? Maybe JQuery? Sorry
update database using two queries at a time
update database using two queries at a time  String sql="insert into employee values(emp_seq.nextval,\'"+ename+"\',\'"+eadd+"\',\'"+ephone... can execute two queries with two different Statement object in the following way
queries
queries  class one having the static variable and method....... we extend class one to class two ..... In clas two if we create a object for class one then we can access the static variable that present in class one
Multiplication of two Matrix
for multiplying two matrix to each other. Here providing you Java source code... matrix will be multiplied to each other by using 'for' loop. So the output... Multiplication of two Matrix    
for each
for each  Sir, is it possible to write bubble sort in java using for each loop ? or any two related nested loops using for each? Thanks in advance
I retrieve a String or other object type without creating a new object each time.
I retrieve a String or other object type without creating a new object each time.  How can I retrieve a String or other object type without creating a new object each time
How to select Data Between Two dates in Java, MySQL
How to select Data Between Two dates in Java, MySQL  How to select Data Between Two dates in Java, MySQL? Thanks in advance.   http://www.v7n.com/forums/coding-forum/294668-how-select-data-between-two-dates-php
select one item name throug combo box than other combobox show item price
select one item name throug combo box than other combobox show item price  i have one table in database item master..if i select one item name through combo box than other combobox show item price only select item name... how i
Is session depend on cookie ???
Is session depend on cookie ???  Since I created one session & as we say that session store at server side that means if I clear browser cookie thereafter it should show me my login use as logged in but when i cleared
mysql run multiple queries at once
mysql run multiple queries at once  Running two MySQL queries at a time in PHP mysql_query
doubts for sub queries in mysql
doubts for sub queries in mysql  how to display the details of one table by checking the conditions in the next table using some condition eg., mysql> select * from student where number=(select id from studentpersonal where
Activity display dynamically depend on the locale on Struts
Activity display dynamically depend on the locale on Struts  i want... and that depend on the Locale (like English or French) . dynamically means user can be expend or collapse (add or delete) activity at run time. I have two
JPA Native Queries, JPA Native Queries Tutorials
JPA Native Queries       In this section, you will know about the jpa native queries and how to use native query in your JPA application.  JPA Native Queries: JPA native
Hibernate named queries
Hibernate named queries  Hi, What is named queries in Hibernate? Thanks
SQL QUERIES GUIDANCE
SQL QUERIES GUIDANCE  I have a query which returns 10 rows and 10 columns. Person_Id is primary key. The result set may be like Person_id Name, City, Telephone 1 Siva Pondy 1123 For each person_id
What are criteria Queries in Hibernate?
What are criteria Queries in Hibernate?  Just explain me what is Criteria Query in Hibernate with examples? Thanks   Criteria queries are very helpful in hibernate for queries based on certain criteria. Check
3 queries on java class
3 queries on java class  Hey. I need to do 3 queries on same class ( JAVA) One is to populate the combobox, the another one to populate tje jlist and the last one to use on button to open a file from database (BLOB) Can some
sql tips for optimizing queries
to optimize sql queries ?   Optimizing SQL Query Remove user-defined inline... actions with set-based queries Archive old data Avoid cursors   Optimizing... and the ways to replace cursors and looping actions with set-based queries Archive old
Need help with nested queries
Need help with nested queries  Hello, Table1 has "id", "votes" columns. Table2 has "id", "Name" column. I need to retrieve Name and its corresponging Votes. I tried with nested queries but its confusing. Can anyone please help
ejb3.0 join queries - EJB
; SELECT STRAIGHT_JOIN ArticleTitle, Copyright, CONCAT_WS(' ', AuthorFirstName
jmeter queries - Development process
Requests : How to select from listbox and click on Signin Button ? (e;g:Login
how to get description for each file
how to get description for each file  hi, how to get description for each file using php or java script..... condtion:two text boxes for each file if the user select 10 file to upload........get the description
to add on to my queries - Java Beginners
Netbean IDE when I run that queries using the last solution provided. I'm puzzled...: [Microsoft][ODBC Microsoft Access Driver] The SELECT statement includes a reserved
JPA Sub-Queries
JPA Sub-Queries       In this section, you will see how to use sub-queries in your JPA application. Sub-queries allows you for querying the vast number of data
Java Check Permutations of String
to check whether two strings are permutations of each other. You are all aware... of each other."); } else{ System.out.println("Strings are not permutations of each other."); } } } Description of Code
Hibernate Polymorphic Queries
Hibernate Polymorphic Queries In this tutorial you will learn about the HQL polymorphic queries. Hibernate supports the polymorphic queries. Polymorphic... = sessionFactory.openSession(); Query query = session.createQuery("select s.empId, s.name
Joining two table using Natural Left join
to each other according to common field, but the priority is given... that have no match in Left Table. Query for Left Join SELECT *FROM employee NATURAL LEFT JOIN Emp_sal The two tables before Left join -- "
select query
select query  how to write select query with where clause having multiple variables. example: i want to select the data from DB in which i want to check againest two variable in where cluase. String sql = "select * from

Ads

Advertisement