• SQL query for max 5 salary from each month separately

    I need a SQL QUERY to select highest 5 salary of employees in each month separately. Can someone help?

    ASWATHY12345 pointsBadges:
  • Update table in Database through linked server

    I want to update my TableA on my ServerA by using linked server which is on serverB.I have successfully created the linked server but i am a little bit confused. Actually i have to update a columnA of TableA from the data coming from columnB(TableB) of linked server on the basis of the matched...

    hussainahmad15 pointsBadges:
  • How can I get a list of SQL Server queries that are running?

    Would anyone happen to know if there's a way I can get a list of queries that are currently running on my SQL Server? I noticed that I have a large query that's running on one of my database servers and I have to stop it. Thanks!

    ITKE409,090 pointsBadges:
  • SQL: In responsiblity wise last 5 transactions details request as on 31.03.2016

    AS per audit review request: All responsibility wise  AP, AR, GL, CM , FA , PO, Inv last 5 transactions taken from the sql as given date for 31.03.2016.  Please help on our request.

    Thillainathan5 pointsBadges:
  • #1064 Database importing error

    I am getting this error when I import the database in phpMyAdmin. Only few tables is imported. SQL query: <!-- PMA-SQL-ERROR --> <div class="error"><h1>Error</h1> <p><strong>SQL query:</strong> <a...

    afaf915 pointsBadges:
  • SQL query: Fetch all records from date field

    Hi, How to fetch all records from the date field less than current date's records provided date field format is centuray(C):YY/MM/DD Thanks.

    6r1,765 pointsBadges:
  • How to find 10 sequencing date for today in SQL query

    It's like date 1 2 3 4 5 6 7 8 9 10 with month and year. How can I do this using a SQL query?

    sundramkharya5 pointsBadges:
  • Display only the duplicate records in SQL

    I need a query to display only the duplicate records alone. For an example, distinct filtr the duplicate records and displays the actual record. Here I need only duplicate records.

    NARMATA50 pointsBadges:
  • SQL query replacing not in

    I wrote this query with not in replace the not in with not exist. SELECT LASTNAME , TITLE FROM NOR_EMPLOYEES WHERE EMPLOYEE_ID not in (SELECT E1.EMPLOYEE_ID FROM NOR_EMPLOYEES E1,NOR_EMPLOYEES E2 WHERE E1.EMPLOYEE_ID=E2.REPORTS_TO);

    vscbobbadi5 pointsBadges:
  • SQL Query: $DB_UPDATEABLE

    What can I do with this SQL query? $db_updatetable = new Database(); $db_updatetable->connect(); $db_updatetable->update(FUND_SUMMARY,$fval,'bank_name="'.$fval['bank_name'].'Query

    karthi3232875 pointsBadges:
  • Run SQL query with CSV format

    I'm trying to run a SQL query from my Linux command line and getting the result in a CSV format. Here's what I have so far: mysql -u uid -ppwd -D dbname << EOQ | sed -e 's/ /,/g' | tee list.csv select id, concat("\"",name,"\"") as name from students EOQ And here's my issue: The columns that...

    ITKE409,090 pointsBadges:
  • Removing MySQL rows from a table using SQL Query

    In MySQL, I have a table that currently holds the following topics: id url title company site_id So I have to go in and remove the rows that have the same title, company and Site_ID. Can this be done using a SQL Query? Thank you!

    ITKE409,090 pointsBadges:
  • SQL Server: Use N prefix before string

    In SQL Server, should I use the N prefix before string for my Transact SQL query? I'm working with a new database and I'm not getting any results back using this: SELECT * FROM a_table WHERE a_field LIKE '%а_pattern%' But, when I add the N prefix before %a_pattern%, it works. Appreciate the help.

    ITKE409,090 pointsBadges:
  • SQL Server: Query is filling up TEMPDB database

    I'm using SQL Server and my partner and I need to figure out how we can identify which query / stored procedure continues to fill up our trans log in our TEMPDB database. It's really starting to become an issue. Thank you.

    ITKE409,090 pointsBadges:
  • Automating a SQL query

    I want to run a SQL query automatically and getting the output in Outlook from remote desktop daily. How do I automate it?

    ansarkhan5 pointsBadges:
  • Move SQL query results to another table

    I have this query: SELECT a.* FROM devices_staging a INNER JOIN ( SELECT ComputerName, MAX(SystemSync) max_date FROM devices_staging GROUP BY ComputerName ) b ON a.ComputerName = b.ComputerName AND a.SystemSync = b.max_date And the results I get are correct. How do I move these results to another...

    icelander5 pointsBadges:
  • SQL query: Find out the count of employee whose name is more than one time

    In SQL, how do I find out the count of employee whose name is more than one time in a table?

    meghanap5 pointsBadges:
  • Get all table names by SQL

    Hi, How can I get all the table names of a bib by a SQL-query? Thank you.

    Oli0015 pointsBadges:
  • Create a sequence called Store_seq with the following values: increment by 10, start with 500

    Create a sequence called Store_seq with the following values: increment by 10, start with 500

    VB RD45 pointsBadges:
  • SQL query for employees in my department

    We need to find 50% of employee from each department, who is getting max salary. And every department have different employee count. ex. finance may have 100 employees and sale may have 40 employee. How do I write a query for this?

    mukeshkumar1230 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following