Sql

Search

subquery in mysql

SELECT date(uploaded_date) FROM `tbl_attach_po_docs` where type_id=1 and attach_po_doc_id = (SELECT max(attach_po_doc_id) where type_id=1) limit 1;

//or
SELECT if(max(attach_po_doc_id) && type_id =1,date(uploaded_date),'') FROM `tbl_attach_po_docs` where 1

Comment

PREVIOUS	NEXT

Code Example
Sql :: postgres insert into table
Sql :: how to replace null values in sql
Sql :: how to average max mysql
Sql :: Search In the Database using Text
Sql :: postgres add prefix to primary key
Sql :: sql order of execution
Sql :: show sql property syntax for jpa.
Sql :: selecting specific day in colum sql
Sql :: drop domain postgresql
Sql :: Inserting data into different tables at once in oracle sql
Sql :: oracle INTERVAL DAY to second to number
Sql :: oracle datafile max size 32gb
Sql :: mysql remove tabs from string
Sql :: postgresql insert multiple rows
Sql :: sql server get date of previous sunday
Sql :: sql limit clause
Sql :: mysql create view
Sql :: change column in mysql
Sql :: postgres create trigger if not exists
Sql :: t sql first and last day of week
Sql :: insert data to postgresql from excel
Sql :: equi joins in oracle
Sql :: database passwords from dbeaver
Sql :: data types mysql vs postgresql
Sql :: hyphen error in database mysql
Sql :: sql online compiler
Sql :: sql stored procedure output parameters
Sql :: TSQL convert csv to table
Sql :: sql query interview questions githu
Sql :: fanyi

Search

SQL

subquery in mysql

ADD CONTENT